/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 vote154 views1 answer
Wordpress query to get posts by post meta
TypeScript
0 vote164 views1 answer
Ts construct signature
TypeScript
0 vote172 views1 answer
Adonis route group
TypeScript
0 vote168 views1 answer
Testing in different environments
TypeScript
2 votes156 views1 answer
Laravel model dont exists id
TypeScript
8 votes156 views3 answers
Update local angular cli
TypeScript
0 vote155 views1 answer
Angular viewchild second parameter
TypeScript
2 votes175 views1 answer
MySQL cheatsheets
TypeScript
35 votes171 views3 answers
Module.exports multiple functions
TypeScript
0 vote155 views1 answer
Online doctor appointments in pakistan
TypeScript