/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 vote275 views1 answer
Typescript string null or white space
TypeScript
4 votes264 views2 answers
Wht we need migrationts in django
TypeScript
0 vote249 views1 answer
Typescript iterate over interface
TypeScript
0 vote246 views1 answer
@ViewChild takes 2 arguments error
TypeScript
0 vote242 views1 answer
Ts add property to interface
TypeScript
0 vote256 views1 answer
Check in Recat if an url is of image or video
TypeScript
2 votes239 views1 answer
Google sheets reference cell static
TypeScript
1 vote248 views1 answer
Create an anonimus object in angular
TypeScript
0 vote256 views1 answer
Simulate click typescript
TypeScript
37 votes307 views3 answers
Angular date pipe 24 hour format
TypeScript