/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 vote108 views1 answer
Difference between test strategy vs test plan
TypeScript
1 vote101 views1 answer
Xaraktirismos tou tsiganou kai tou xose buendia sto keimeno 100 xronia monaksias, oi nees efeureseis
TypeScript
2 votes69 views1 answer
Mysql update if exists else leave
TypeScript
0 vote106 views1 answer
Createasyncthunk with typescript
TypeScript
1 vote111 views1 answer
Property 'mozRequestFullScreen' does not exist on type 'HTMLElement'. Did you mean 'requestFullscreen'?
TypeScript
0 vote111 views3 answers
Online js to typescript converter
TypeScript
0 vote90 views2 answers
How to hack a roblox password
TypeScript
2 votes124 views1 answer
Allegro gdzie jest moja paczka
TypeScript
1 vote116 views1 answer
Two plots side by side r
TypeScript
0 vote116 views1 answer
Print all objects linked list python
TypeScript