/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 vote145 views1 answer
How to add enchantments to mobs plugin
TypeScript
0 vote153 views1 answer
Powershell copy contents of keyvault to another keyvault
TypeScript
0 vote168 views1 answer
Python multiple named imports on one line
TypeScript
17 votes146 views3 answers
Typescript enum to string
TypeScript
1 vote170 views1 answer
Adonis identify method
TypeScript
0 vote212 views1 answer
--virtualbox-no-vtx-check
TypeScript
0 vote153 views1 answer
Createasyncthunk with typescript
TypeScript
0 vote145 views1 answer
Create dict of value to index from list python
TypeScript
4 votes107 views1 answer
Typescript define return type based on parameter
TypeScript
1 vote151 views2 answers
Add class to element angular in ts
TypeScript