/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 vote141 views1 answer
They Take Their Medication Then The Device Owner Lets Them Press The Button | The Problem We Are Solving Is Kids Not Taking Their Medication Which Turns To Great Health Benefits In The Young Generation
TypeScript
1 vote137 views1 answer
Angular typescript set meta data
TypeScript
0 vote146 views1 answer
Vue 3 bootstrap 5 tooltip
TypeScript
5 votes108 views3 answers
: mysqli_fetch_array() expects parameter 1 to be mysqli_result, array given
TypeScript
0 vote138 views1 answer
Type script array declaration
TypeScript
0 vote185 views1 answer
Bibtex remove brackets in note field
TypeScript
0 vote139 views2 answers
Distance between two lat long points google maps api
TypeScript
-2 votes149 views1 answer
How to randomly generate a string in ts
TypeScript
19 votes140 views5 answers
Cannot use import statement outside a module typescript
TypeScript
0 vote138 views2 answers
Unique list typescript
TypeScript