/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 vote119 views1 answer
How to add new row to a particular index of a ag grid using angular 7
TypeScript
0 vote136 views1 answer
How to separate elements in list python
TypeScript
1 vote129 views1 answer
Get minutes between two dates ts
TypeScript
1 vote135 views1 answer
Git lits file in commit
TypeScript
-1 vote143 views1 answer
Create database if not exists mysql true spring boot
TypeScript
15 votes160 views3 answers
Can't bind to 'formGroup' since it isn't a known property of 'form
TypeScript
14 votes170 views1 answer
Ngbmodal angular 9 yarn install
TypeScript
0 vote128 views1 answer
Module.exports mongodb connection
TypeScript
0 vote206 views1 answer
How to restrict alphabets in input field in angular
TypeScript
0 vote149 views1 answer
Sort function in typescript
TypeScript