/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

5 votes208 views1 answer
Python how to check if all elements in list are the same
TypeScript
0 vote207 views1 answer
Tag for bullets in html
TypeScript
1 vote195 views1 answer
Readonly vs const
TypeScript
15 votes285 views5 answers
Typescript random int
TypeScript
0 vote210 views1 answer
Add bullet points in text widget flutter
TypeScript
0 vote216 views1 answer
Typeorm data array from relation
TypeScript
0 vote229 views1 answer
Stripe create customer
TypeScript
0 vote217 views1 answer
Give each of the radio and checkbox inputs the value attribute. Use the input label text, in lowercase, as the value for the attribute.
TypeScript
0 vote198 views1 answer
What will be the result of the cp /etc/hosts . command?
TypeScript
2 votes211 views1 answer
Vue\npm\vue.ps1 cannot be loaded because running scripts is disabled on this system
TypeScript