/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 vote156 views1 answer
How to update objects in locall storage
TypeScript
0 vote143 views1 answer
React onclick action starts automatically
TypeScript
0 vote148 views1 answer
How to pass node arguments in nextjs
TypeScript
0 vote163 views1 answer
How to check if file exists lua
TypeScript
-1 vote153 views1 answer
What are the components of the environment? Explain it along with the examples.
TypeScript
0 vote150 views1 answer
Ts remove first 0 number from string
TypeScript
0 vote164 views1 answer
Typescript make object optional
TypeScript
0 vote148 views1 answer
Let variable name : any = () => { return new typescript fie}
TypeScript
0 vote173 views1 answer
Django model get all documents with a given foreign key
TypeScript
0 vote144 views2 answers
Python remove all double elements from list
TypeScript