/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

10 votes256 views3 answers
Mongodb find starts with
TypeScript
0 vote254 views1 answer
How to print list contents in java
TypeScript
0 vote248 views1 answer
Prototype design pattern typescript
TypeScript
0 vote253 views1 answer
Directory. Relative imports outside of src/ are not supported.
TypeScript
0 vote252 views1 answer
DISTINQUISH BETWEEN THE AVERAGE CASE AND WORSE CASE RUNNING TIME AND THE FACTORS AFFECTING THAT AFFECTS THE RUNNING TIME OF AN ALGORITHM
TypeScript
4 votes257 views2 answers
Magento 2 enable template hints command line
TypeScript
19 votes278 views5 answers
Delete all documents in a collection mongodb
TypeScript
1 vote254 views2 answers
Json in typescript
TypeScript
0 vote260 views1 answer
"Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryInterface", but its service could not be found. Make sure the service exists and is tagged with "doctrine.repository_service".
TypeScript
0 vote259 views1 answer
Java write arraylist of objects to file
TypeScript