/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

1 vote98 views1 answer
Ionic 4 set root page when logout
TypeScript
-1 vote101 views1 answer
Alert cannot operate on nodes the current scene inherits from
TypeScript
0 vote125 views1 answer
Get all elements with id starts and class
TypeScript
2 votes141 views2 answers
String to date in typescript
TypeScript
-1 vote106 views1 answer
10 elements of gothic literature
TypeScript
46 votes159 views6 answers
Install requests python
TypeScript
2 votes117 views1 answer
Type of setinterval typescript
TypeScript
14 votes107 views3 answers
Df.value_counts to dataframe
TypeScript
1 vote101 views1 answer
Move items from one log to another typescript
TypeScript
0 vote148 views1 answer
Adding html in typescript
TypeScript