/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 vote189 views1 answer
Whats my name
TypeScript
5 votes198 views3 answers
Mat-form-field must contain a MatFormFieldControl
TypeScript
0 vote272 views1 answer
How to auto collect channel points twitch
TypeScript
-1 vote222 views1 answer
Create database if not exists mysql true spring boot
TypeScript
0 vote291 views1 answer
Typescript type plus one property
TypeScript
0 vote197 views1 answer
Input type file in html events angular
TypeScript
0 vote254 views1 answer
How to get class weights while using keras imagedatagenerator
TypeScript
0 vote201 views1 answer
Typescript split/partition array by condition
TypeScript
1 vote206 views1 answer
Adonis preload recursive
TypeScript
0 vote205 views1 answer
Convert javascript to typescript
TypeScript