/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 vote177 views1 answer
Object notation string javascript\
TypeScript
0 vote190 views1 answer
C# get all elements from list
TypeScript
0 vote200 views1 answer
Css proferties throught ts
TypeScript
2 votes194 views1 answer
React.children
TypeScript
13 votes214 views3 answers
How to check whether a string contains a substring in typescript online
TypeScript
0 vote193 views1 answer
How to create a record array from lists in python
TypeScript
0 vote221 views1 answer
Auto complete of process.env in typescript
TypeScript
0 vote192 views1 answer
Cannot find module '@angular/cdk/a11y'
TypeScript
0 vote181 views1 answer
How to make a dictionary of indices and lists python
TypeScript
0 vote227 views1 answer
Em is relative to its font size
TypeScript