/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 vote190 views1 answer
Roblox how to weld parts together using script
TypeScript
0 vote188 views1 answer
How to check if there is any point which lies inside the circle
TypeScript
0 vote224 views1 answer
'`pydot` failed to call GraphViz.' OSError: `pydot` failed to call GraphViz.Please install GraphViz (https://www.graphviz.org/) and ensure that its executables are in the $PATH.
TypeScript
0 vote195 views1 answer
Ts(2503)
TypeScript
0 vote194 views1 answer
Keep footer after all elements react
TypeScript
0 vote182 views2 answers
Typescript key value loop
TypeScript
2 votes186 views2 answers
Remove all the elements from a numpy array python
TypeScript
0 vote213 views1 answer
Wordpress get_posts custom posts by meta key
TypeScript
10 votes187 views2 answers
How to use variable as object key in typescript
TypeScript
1 vote202 views1 answer
Roblox finding points around a circle using radius, center, and angle
TypeScript