/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 vote270 views1 answer
Typescript recursive partial
TypeScript
-1 vote259 views1 answer
Top data scientists in the world
TypeScript
1 vote226 views1 answer
Sonar properties exclude rule
TypeScript
0 vote229 views1 answer
Admin_enqueue_scripts specific page
TypeScript
0 vote241 views1 answer
Servlets meaning
TypeScript
0 vote252 views2 answers
Window.print div
TypeScript
2 votes198 views1 answer
Mat-option change event
TypeScript
0 vote313 views1 answer
Git rebase two commits to one
TypeScript
0 vote230 views1 answer
Check already exists from non deleted rows laravel
TypeScript
0 vote237 views1 answer
Nativescript date input validation
TypeScript