/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 vote90 views1 answer
Ngx-numeral
TypeScript
0 vote99 views1 answer
How to separate real and imaginary parts of a complex number in python
TypeScript
0 vote109 views1 answer
Typescript key as string
TypeScript
1 vote95 views1 answer
Main concepts in asp.net core
TypeScript
0 vote108 views1 answer
Path represents file or directory java
TypeScript
-1 vote104 views1 answer
2d array of strings and ints python
TypeScript
9 votes100 views4 answers
Angular scroll to top
TypeScript
0 vote98 views1 answer
How to select a column with brackets in jupyter notebook
TypeScript
-1 vote102 views1 answer
Typescript array count
TypeScript
1 vote100 views1 answer
Typescript event keyCode
TypeScript