/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

1 vote179 views1 answer
NullInjectorError: R3InjectorError(ProfilePageModule)[Camera -> Camera -> Camera
TypeScript
0 vote171 views1 answer
Java delete contents of file
TypeScript
0 vote220 views1 answer
Lodash typescript
TypeScript
0 vote190 views1 answer
How to make the score add on while its in a loop in python
TypeScript
0 vote170 views1 answer
How to store image in realtime firebase using angularfire2 and angular 8
TypeScript
0 vote177 views2 answers
Ncbi datasets command-line tool
TypeScript
0 vote166 views1 answer
How to make the inputs become a sum python
TypeScript
8 votes176 views3 answers
Futter Rounded Button
TypeScript
0 vote146 views0 answer
TypeScript
0 vote179 views1 answer
Get elements in list in another list c#
TypeScript