Breaking News: Grepper is joining You.com. Read the official announcement!

get distinct elements in table psql

Lively Locust answered on January 27, 2021 Popularity 10/10 Helpfulness 2/10

answer get distinct elements in table psql

get distinct elements in table psql

Comment

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)

Popularity 10/10 Helpfulness 2/10 Language typescript

Source: www.enterprisedb.com

Tags: distinct elements get psql typescript

Link to this answer
Share Copy Link

Contributed on Jan 03 2022

Lively Locust

0 Answers Avg Quality 2/10

Closely Related Answers

postgresql distinct

Comment

SELECT
	DISTINCT bcolor
FROM
	distinct_demo
ORDER BY
	bcolor;

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.postgresqltutorial.com

Tags: distinct distinc

Link to this answer
Share Copy Link

Contributed on Jan 27 2021

GutoTrosla

0 Answers Avg Quality 2/10

select distinct postgres

Comment

-- NOTE: SELECT DISTINCT ON expressions must match initial ORDER BY expressions


SELECT
   DISTINCT ON (column1) column_alias,
   column2
FROM
   table_name
ORDER BY
   column1,
   column2;
Code language: SQL (Structured Query Language) (sql)

-- EXAMPLE
SELECT
   DISTINCT on (client_id) client_id, id
FROM
   public.dw_client_plan_histories
   where operation = 4
        and original_created_at >= '2022-06-17';

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.postgresqltutorial.com

Tags: distinct distinc

Link to this answer
Share Copy Link

Contributed on Jun 17 2022

Tiago F2

0 Answers Avg Quality 2/10

get distinct elements in table psql

Contents

More Related Answers

get distinct elements in table psql

Closely Related Answers

postgresql distinct

select distinct postgres

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.