/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 vote156 views1 answer
Pass command line arguments with spaces cmd
TypeScript
0 vote176 views1 answer
From __future__ import unicode_literals import youtube_dl ydl_opts = {} with youtube_dl.YoutubeDL(ydl_opts) as ydl: ydl.download(['VideoURL'])
TypeScript
1 vote247 views1 answer
How to count positive elements numpy
TypeScript
0 vote251 views2 answers
Register service worker
TypeScript
0 vote201 views1 answer
Typescript get class properties
TypeScript
0 vote315 views1 answer
Styled components type argument generic
TypeScript
0 vote168 views1 answer
Pytest tests in subfolder
TypeScript
1 vote159 views1 answer
Mongo find documents that have a certain key
TypeScript
2 votes157 views1 answer
Get all the game objects in a scene unity
TypeScript
0 vote150 views1 answer
(function (global, factory) { typeof exports === 'object' && typeof module !== 'undefined' ? module.exports = factory() : typeof define === 'function' && define.amd ? define(factory) : (global.Popper = factory());
TypeScript