/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 vote270 views1 answer
Mysql database exists or not
TypeScript
1 vote321 views1 answer
'mat-label' is not a known element:
TypeScript
10 votes280 views3 answers
Typescript foreach
TypeScript
0 vote281 views2 answers
How to compare two entity objects in c# to update
TypeScript
0 vote274 views1 answer
Check if email exists firebase
TypeScript
9 votes381 views5 answers
Python requests use proxy
TypeScript
0 vote304 views2 answers
Pywavelets tutorial
TypeScript
6 votes288 views1 answer
An unhandled exception occurred: Cannot find module '@angular-devkit/build-angular/package.json'
TypeScript
0 vote264 views1 answer
How to reorder boxplots in ggplot
TypeScript
0 vote290 views1 answer
Typscript to string
TypeScript