/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 vote299 views1 answer
How to add enchantments to mobs plugin
TypeScript
0 vote305 views1 answer
Dotcms elasticsearch query
TypeScript
0 vote321 views3 answers
How to bold to custom fonts on Online
TypeScript
0 vote260 views1 answer
Type script
TypeScript
1 vote329 views1 answer
Passing variable data to laravel component
TypeScript
25 votes278 views10 answers
Github
TypeScript
3 votes356 views2 answers
@ts ignore file
TypeScript
0 vote276 views1 answer
Check if username exists in database django
TypeScript
3 votes285 views1 answer
Ionic web platform
TypeScript
0 vote276 views1 answer
Find unique values between 2 lists R
TypeScript