/SQL/Choose only one for each distinct collumn regardless of other columns

Choose only one for each distinct collumn regardless of other columns

Choose only one for each distinct collumn regardless of other columns

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

0

Source: codeproject.com

Similar codes

0 vote293 views1 answer
Sql change default collation to utf8
SQL
0 vote306 views1 answer
Where case insensitive like mysql
SQL
0 vote315 views1 answer
Sql server beginning of month
SQL
2 votes299 views4 answers
How to find 2nd highest salary in mysql
SQL
8 votes334 views2 answers
Phpmyadmin default password
SQL
9 votes301 views1 answer
Oracle get table schema
SQL
0 vote301 views1 answer
Mysqlimport
SQL
0 vote297 views1 answer
Rabbitmq service not starting
SQL
0 vote294 views1 answer
Create domain sql
SQL
0 vote308 views1 answer
Get only structure database mysql
SQL

Share