/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 vote278 views3 answers
Woocommerce remove This is where you can add new products to your store in taxonomy description
TypeScript
0 vote251 views1 answer
Fjnction by parts latex
TypeScript
0 vote262 views1 answer
Move between points in godot
TypeScript
1 vote279 views1 answer
Ts partial record
TypeScript
20 votes315 views10 answers
Nodemon
TypeScript
0 vote244 views1 answer
Which of the following object types below cannot be replicated
TypeScript
1 vote285 views1 answer
React typescript input set focus dinamically
TypeScript
0 vote271 views2 answers
Spritesheets in pyqt
TypeScript
18 votes332 views3 answers
ReferenceError: fetch is not defined
TypeScript
0 vote258 views1 answer
Text size in plots in r
TypeScript