nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to select unique record based on 1 column

Dhiraj Kr_ Gupta

Name ID Age

John. 12. 14

Snow. 13. 16

John. 12. 18

Ken. 14. 19

Snow. 13. 17

I want to get only those records having distinct I'd order by age

Output

John. 12. 14

Snow. 13. 16

Accepted answers

Stiltsoft support

Hi @Dhiraj Kr_ Gupta ,

You may try to "play" with the following SQL query:

Wed 10-1.png

SELECT *,
MIN('Age') AS 'Minimum Age'
FROM T*
GROUP BY 'ID', 'Name'

Wed 10-2.png

Hope it helps your case.

All comments

Stiltsoft support

Hi @Dhiraj Kr_ Gupta ,

You may try to "play" with the following SQL query:

Wed 10-1.png

SELECT *,
MIN('Age') AS 'Minimum Age'
FROM T*
GROUP BY 'ID', 'Name'

Wed 10-2.png

Hope it helps your case.

Dhiraj Kr_ Gupta

Thanks for your reply

But I have same date for two records instead of Age

How can I assign rank in that case.

I need to add a time stamp for each record which is unique for each record

Stiltsoft support

You may add only current time stamp or date for the whole column with the help of the Table Transformer macro (automatically, I mean). Later this current date can be compared to other dates (to calculate the difference between now and due date, for example).

But if to talk about ranking, maybe standard row autonumbering will suit you? If you add new entries only in the end of your table (you don't add rows randomly between existing rows), then the most recent entries will have the biggest row numbers. You'll use the MAX function instead of MIN and the row numbers appear automatically when you add a new table row.