/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

2 votes335 views1 answer
Removing view
SQL
0 vote330 views1 answer
Oracle sql log to console
SQL
11 votes330 views3 answers
Sqlite3 create table from another table
SQL
0 vote335 views1 answer
Radius search with point data in mysql
SQL
32 votes343 views6 answers
How to change column name in sql
SQL
0 vote385 views1 answer
Différence entre deux dates sql oracle
SQL
2 votes324 views1 answer
Mysql how to store lat,lng
SQL
3 votes348 views2 answers
@sqlresultsetmapping
SQL
2 votes329 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
-2 votes319 views1 answer
Modify column name in tsql
SQL

Share