/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

7 votes197 views1 answer
Sort list of objects python
TypeScript
0 vote182 views1 answer
Whats my name
TypeScript
0 vote178 views1 answer
Angular type of string
TypeScript
2 votes189 views1 answer
Types date typescript
TypeScript
0 vote193 views1 answer
How to create a record array from lists in python
TypeScript
0 vote207 views1 answer
Typescript clearinterval not working
TypeScript
0 vote194 views1 answer
Nullish Coalescing
TypeScript
14 votes237 views4 answers
React input onchange typescript
TypeScript
0 vote197 views1 answer
IM DEAD
TypeScript
0 vote230 views1 answer
Property 'editor' does not exist on type 'Window & typeof globalThis'.
TypeScript