/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

6 votes188 views2 answers
Typescript random boolean
TypeScript
0 vote221 views1 answer
Write a prolog program to find the sum of elements in given list.
TypeScript
0 vote211 views1 answer
Typescript trim spaces in string array
TypeScript
13 votes215 views4 answers
Change checkbox jquery alert
TypeScript
0 vote193 views1 answer
From date and to date validation in angular 8
TypeScript
0 vote199 views1 answer
Move between points in godot
TypeScript
1 vote238 views1 answer
Execute only one test spec with angular-cli (ng test)
TypeScript
11 votes190 views1 answer
How to select last 2 elements in a string python
TypeScript
1 vote183 views1 answer
Benefits eat halim plant leaves
TypeScript
0 vote210 views5 answers
Rosa
TypeScript