/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

3 votes249 views1 answer
ERROR in node_modules/rxjs/internal/types.d.ts(81,44): error TS1005: ';' expected.
TypeScript
57 votes512 views3 answers
How to check list of open ports in linux
TypeScript
0 vote178 views1 answer
Res.write prints html tags as text in express
TypeScript
0 vote167 views1 answer
Typescript array to string
TypeScript
1 vote221 views1 answer
Header imitate python
TypeScript
0 vote175 views1 answer
Useappdispatch
TypeScript
1 vote178 views2 answers
Typescript null and undefined check
TypeScript
0 vote183 views1 answer
Get date list from date of range in react ts
TypeScript
0 vote176 views1 answer
How to get remainder in typescript
TypeScript
3 votes176 views1 answer
Check if key exists in json typescript
TypeScript