/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 vote278 views3 answers
Typescript with babel
TypeScript
0 vote340 views1 answer
Whats the difference between let and const lol
TypeScript
1 vote266 views1 answer
Serenity.is Entity service async to sync requests
TypeScript
0 vote287 views1 answer
Grants ORACLE
TypeScript
0 vote255 views1 answer
How to round float to 2 decimal places
TypeScript
0 vote264 views1 answer
O arquivo yarn.ps1 não pode ser carregado porque a execução de scripts foi desabilitada neste sistema
TypeScript
0 vote280 views1 answer
Delete the last string from file in typescript
TypeScript
0 vote314 views1 answer
Fputs c++
TypeScript
0 vote254 views1 answer
Onblur typescript
TypeScript
1 vote320 views1 answer
How to convert millisecond to second to date momentjs
TypeScript