/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 vote283 views1 answer
Typescript triple slash
TypeScript
0 vote224 views1 answer
Searching filtering ibraries in angular
TypeScript
0 vote245 views2 answers
Is subscribing to a lot of events in ngonint bad
TypeScript
8 votes218 views5 answers
Google fonts cdn link
TypeScript
1 vote228 views1 answer
Canactivate get current url
TypeScript
0 vote263 views1 answer
Django model get all documents with a given foreign key
TypeScript
0 vote245 views1 answer
Print file contents in git bash
TypeScript
0 vote284 views1 answer
Vi highlights word
TypeScript
3 votes207 views1 answer
Can't bind to 'formcontrol' since it isn't a known property of 'input'.
TypeScript
1 vote244 views1 answer
How to display server count on discord.js
TypeScript