/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 vote168 views1 answer
Tes ssh gitlab
TypeScript
0 vote167 views1 answer
Print contents of cpp file
TypeScript
0 vote278 views3 answers
How to navigate from one page to another in angular
TypeScript
0 vote198 views1 answer
Wergensherts meaning
TypeScript
2 votes203 views1 answer
Check typescript version
TypeScript
2 votes184 views2 answers
Typescript datetimte
TypeScript
10 votes284 views1 answer
Expo.ps1 cannot be loaded because running scripts is disabled on this system. for more information
TypeScript
0 vote159 views2 answers
Defining component layout next ts
TypeScript
0 vote170 views1 answer
Ionic scroll to item programmatically
TypeScript
2 votes235 views2 answers
Eslint no-unused-vars typescript
TypeScript