/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

4 votes142 views3 answers
Find distance between two points in opencv python
TypeScript
1 vote155 views1 answer
Typescript how to add a property to an object
TypeScript
7 votes181 views4 answers
Array in typescript
TypeScript
0 vote139 views1 answer
Typescript array of object findindex
TypeScript
1 vote152 views1 answer
React-draggable disable
TypeScript
0 vote268 views1 answer
Git rebase two commits to one
TypeScript
0 vote145 views1 answer
Cacerts default password
TypeScript
1 vote140 views1 answer
Two plots side by side r
TypeScript
0 vote152 views1 answer
Pdfunite all documents in a folder with alphabetical order
TypeScript
1 vote143 views1 answer
Vue components import each other recursive
TypeScript