/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

11 votes116 views1 answer
How to select last 2 elements in a string python
TypeScript
0 vote112 views1 answer
Whats the next sonic game
TypeScript
1 vote141 views1 answer
File C:\Users\skill\AppData\Roaming\npm\yarn.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
0 vote134 views1 answer
Ts date toisostring incorrect conversion
TypeScript
0 vote117 views1 answer
Which of the foolowing ia an element of pallette that holds multiple elements of nspecific purpose
TypeScript
0 vote132 views1 answer
Get elements in list in another list c#
TypeScript
0 vote136 views1 answer
When to choose automation over manual testing
TypeScript
1 vote119 views1 answer
Typescript type of component
TypeScript
0 vote135 views1 answer
File reader with promise
TypeScript
0 vote149 views1 answer
Css all inoputs not checkbox
TypeScript