/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 vote114 views1 answer
Type alias in typescript
TypeScript
0 vote112 views1 answer
Match a string that starts and ends with the same vowel
TypeScript
1 vote110 views1 answer
What is typescript in angular
TypeScript
-1 vote104 views1 answer
Java list of objects example
TypeScript
0 vote115 views1 answer
DecoDe query string to object javascript
TypeScript
0 vote122 views1 answer
Counts of unique values in rows of given 2D array numpy
TypeScript
0 vote108 views6 answers
How to add typescript tp create react app
TypeScript
0 vote116 views1 answer
How to compile ts in cmd
TypeScript
-1 vote125 views2 answers
Typescript initialize object
TypeScript
6 votes114 views1 answer
File C:\Users\SHUBHAM KUNWAR\AppData\Roaming\npm\nodemon.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript