/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 vote322 views1 answer
Will Tenet come in plate format
TypeScript
0 vote344 views1 answer
How to compra vales on lists python
TypeScript
0 vote347 views1 answer
Nuxt typescript middleware property
TypeScript
0 vote376 views2 answers
Bootstrap dropdown menu not showing
TypeScript
3 votes327 views2 answers
Typescript declare window property
TypeScript
1 vote330 views2 answers
Typescript extend multiple classes
TypeScript
0 vote346 views2 answers
How to teleport a sprite to a new room in game maker studio 2
TypeScript
0 vote356 views1 answer
Typescript sort number array descending
TypeScript
0 vote382 views1 answer
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime.
TypeScript
10 votes360 views2 answers
How to use variable as object key in typescript
TypeScript