/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 vote277 views1 answer
Flutter check if app is in foreground
TypeScript
0 vote283 views1 answer
How did mississauga get its name
TypeScript
0 vote323 views1 answer
Remove white border around components angular
TypeScript
0 vote359 views1 answer
Concat and nunll check in typescript
TypeScript
0 vote316 views1 answer
> Could not find method classpath() for arguments [org.jetbrains.kotlin:kotlin-gradle-plugin:1.6.10] on object of type org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler.
TypeScript
53 votes548 views4 answers
Digits of pi
TypeScript
0 vote334 views1 answer
Site:community.nxp.com dts gpio output high active
TypeScript
0 vote367 views1 answer
Typescript open site in frame
TypeScript
0 vote321 views1 answer
How to Convert MATLAB Scripts to Python
TypeScript
0 vote366 views1 answer
How to add 3d objects folder to this pc windows 11
TypeScript