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

choose only one for each distinct collumn regardless of other columns

Add Answer

MonkeySeeMonkeyDo answered on January 25, 2022 Popularity 9/10 Helpfulness 3/10

answer choose only one for each distinct collumn regardless of other columns

related distinct For only one column

related select other columns with distinct

choose only one for each distinct collumn regardless of other columns

Comment

WITH cte AS
(   SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY val1 DESC) AS rn
    FROM MyTable
)
SELECT *
FROM cte
WHERE rn = 1

Popularity 9/10 Helpfulness 3/10 Language sql

Source: www.codeproject.com

Tags: distinct each sql

Link to this answer
Share Copy Link

Contributed on Jan 25 2022

MonkeySeeMonkeyDo

0 Answers Avg Quality 2/10

Closely Related Answers

distinct For only one column

Comment

SELECT *
  FROM (
                SELECT  ID, 
                        Email, 
                        ProductName, 
                        ProductModel,
                        ROW_NUMBER() OVER(PARTITION BY Email ORDER BY ID DESC) rn
                    FROM Products
              ) a
WHERE rn = 1

Popularity 9/10 Helpfulness 3/10 Language whatever

Source: stackoverflow.com

Tags: distinct distinc

Link to this answer
Share Copy Link

Contributed on Jul 06 2022

otmane smiri

0 Answers Avg Quality 2/10

select other columns with distinct

Comment

SELECT * FROM table
WHERE id IN (
  SELECT MAX(id) FROM table GROUP BY name
)

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: distinct distinc

Link to this answer
Share Copy Link

Contributed on Feb 03 2022

Outstanding Orangutan

0 Answers Avg Quality 2/10

choose only one for each distinct collumn regardless of other columns

Contents

More Related Answers

choose only one for each distinct collumn regardless of other columns

Closely Related Answers

distinct For only one column

select other columns with distinct

Grepper

Documentation

Social

Legal

Contact

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