/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 vote148 views1 answer
How to add bootstrap to angular app page
TypeScript
2 votes214 views5 answers
Plot multiple plots in r
TypeScript
5 votes233 views1 answer
Angular navigate to the same route with different parameter
TypeScript
0 vote236 views1 answer
How to align text inside an li to its center
TypeScript
0 vote229 views1 answer
Failed to find '~@nativescript/theme/css/core.css'
TypeScript
0 vote191 views1 answer
Must_not exists elastic search
TypeScript
0 vote186 views1 answer
Combine results from two columns in ms sql
TypeScript
0 vote225 views1 answer
Event
TypeScript
0 vote149 views1 answer
NFS is reporting that your exports file is invalid. Vagrant does this check before making any changes to the file. Please correct the issues below and execute "vagrant reload":
TypeScript
0 vote193 views1 answer
Number of elements in circular queue
TypeScript