/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 vote197 views1 answer
Test events where not received
TypeScript
0 vote195 views1 answer
Nextjs waiting for compiling problem
TypeScript
0 vote218 views3 answers
Please make sure you have the correct access rights and the repository exists.
TypeScript
0 vote204 views1 answer
Angular build Failed to load resource
TypeScript
1 vote191 views1 answer
How to use command line arguments in java eclipse
TypeScript
1 vote189 views1 answer
How to move data between request
TypeScript
5 votes199 views1 answer
Check if column exists in dataframe
TypeScript
0 vote207 views1 answer
Types of pacemaker
TypeScript
12 votes213 views3 answers
If shorthand typescript
TypeScript
0 vote205 views1 answer
Count file lines in typescript
TypeScript