/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

3 votes321 views3 answers
Cannot find module 'typescript' angular 9
TypeScript
1 vote327 views1 answer
Ion2 calendar locale
TypeScript
8 votes340 views1 answer
Python find the number of elements in a list
TypeScript
0 vote347 views1 answer
Function printprops(o) { for(var p in o) console.log(p + ": " + o[p] + "\n"); } What will the above code snippet result ? Prints the contents of each property of o Returns undefined Both a and b None of the mentioned
TypeScript
0 vote351 views1 answer
Type 'T' does not satisfy the constraint 'keyof IntrinsicElements | JSXElementConstructor<any>'.
TypeScript
19 votes325 views5 answers
Cannot use import statement outside a module typescript
TypeScript
3 votes317 views1 answer
How to make s3 bucet objects publicj
TypeScript
26 votes319 views3 answers
How to install typescript in windows 10
TypeScript
1 vote315 views1 answer
Error: Gradle project sync failed. Please fix your project and try again.
TypeScript
0 vote422 views1 answer
Array.join typescript
TypeScript