/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 vote276 views1 answer
Exception: java gateway process exited before sending its port number
TypeScript
0 vote306 views1 answer
Sourcetree winmerge arguments three way merge
TypeScript
0 vote236 views1 answer
Check if username exists in database django
TypeScript
2 votes265 views3 answers
Sum of digits in c++
TypeScript
0 vote257 views1 answer
Group list into sublists python
TypeScript
0 vote246 views1 answer
Vue 3 bootstrap 5 tooltip
TypeScript
1 vote242 views1 answer
Benefits eat halim plant leaves
TypeScript
0 vote260 views1 answer
React hooks typescript function return and receive
TypeScript
4 votes253 views2 answers
Typescript get type
TypeScript
0 vote240 views1 answer
Not able to use fonts awesome in react
TypeScript