/TypeScript/Get distinct elements in table psql

Get distinct elements in table psql

postgres=#  select distinct on (col1) col1,col2,col3 from test order by col1;

 col1 | col2 |    col3    

------+------+------------

    1 | abc  | 2015-09-10

    2 | xyz  | 2015-09-13

    3 | tcs   | 2015-01-15

(3 rows)

Source: enterprisedb.com

Similar codes

0 vote191 views1 answer
Parsing error: File tsconfig.json' not found.eslint
TypeScript
4 votes176 views2 answers
When to do manual testing
TypeScript
1 vote186 views2 answers
Typescript declare process.env
TypeScript
0 vote198 views1 answer
Function to generate random number (typescript)
TypeScript
0 vote175 views1 answer
Typescript namespace example
TypeScript
0 vote203 views1 answer
Can i use different flutter versions for differnt progjects ?
TypeScript
0 vote196 views2 answers
Paths typescript
TypeScript
0 vote184 views1 answer
Google chrome keyboard shortcuts windows
TypeScript
0 vote202 views2 answers
Empty form elements except jquery
TypeScript
0 vote196 views1 answer
Async http requests python - Aiohttp
TypeScript