/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 vote160 views1 answer
Pandas value_counts sort descending
TypeScript
38 votes180 views10 answers
Calculator
TypeScript
0 vote132 views1 answer
Use multy line in typescript
TypeScript
3 votes139 views2 answers
Multi line comments latex
TypeScript
0 vote168 views1 answer
Mongoose get all documents big
TypeScript
0 vote136 views1 answer
RuntimeError: Java gateway process exited before sending its port number site:stackoverflow.com
TypeScript
8 votes171 views3 answers
Angular window scroll to top not working
TypeScript
2 votes134 views2 answers
Props vue typescript
TypeScript
0 vote139 views3 answers
Convert typescript to js online
TypeScript
0 vote135 views2 answers
Li elements horizontally css
TypeScript