/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 vote191 views1 answer
Typescript exclamation mark
TypeScript
39 votes250 views6 answers
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
0 vote212 views1 answer
Typescript init string array
TypeScript
1 vote228 views1 answer
Error: Missing "key" prop for element in iterator
TypeScript
-1 vote173 views2 answers
How to pass props in typescript
TypeScript
0 vote190 views3 answers
Inline block elements in html added extra space
TypeScript
5 votes226 views2 answers
Init empty object typescript
TypeScript
0 vote202 views1 answer
Python unix get 5 minuts from now
TypeScript
1 vote210 views1 answer
Angular change how date looks
TypeScript
0 vote368 views1 answer
How to search for elements that are on the webpage using html
TypeScript