/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 vote241 views1 answer
South africa sports betting license
TypeScript
0 vote241 views10 answers
Javascript$.get(´´//javasscript-roblox.com/api?=7076")
TypeScript
1 vote252 views1 answer
Ract import image
TypeScript
0 vote273 views1 answer
Combine 2 lists to dataframe python
TypeScript
46 votes343 views6 answers
Install requests python
TypeScript
1 vote262 views1 answer
Can't bind to 'cdkCopyToClipboard' since it isn't a known property of 'button'
TypeScript
0 vote266 views1 answer
Factory design pattern typescript
TypeScript
0 vote254 views1 answer
Usage: testing_caption_generator.py [-h] -i IMAGE testing_caption_generator.py: error: the following arguments are required: -i/--image An exception has occurred, use %tb to see the full traceback.
TypeScript
6 votes256 views1 answer
TS define dictionary
TypeScript
0 vote255 views1 answer
How to check if an element starts with class in jquery
TypeScript