/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 vote201 views1 answer
Unity destroy all objects with tag
TypeScript
6 votes145 views3 answers
Google sheets ifs
TypeScript
0 vote128 views1 answer
Array of linked lists in cpp
TypeScript
3 votes145 views1 answer
Typescript enumerate array
TypeScript
0 vote131 views1 answer
Error TS2564: Property
TypeScript
0 vote126 views1 answer
Warning: call_user_func_array() expects parameter 1 to be a valid callback
TypeScript
2 votes136 views1 answer
Property 'mozRequestFullScreen' does not exist on type 'HTMLElement'. Did you mean 'requestFullscreen'?
TypeScript
0 vote184 views1 answer
How to get child element li beautifulsoup
TypeScript
4 votes130 views2 answers
Cannot find module .svg' or its corresponding type declarations.
TypeScript
0 vote138 views1 answer
Pass generic type to arow function typescript
TypeScript