/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 vote244 views1 answer
Sql change primary key to composite key
SQL
0 vote247 views1 answer
Use mysql in java program
SQL
0 vote228 views1 answer
Find and replace database table phpmyadmin
SQL
4 votes222 views1 answer
Wilayah indonesia sql
SQL
0 vote224 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote275 views1 answer
Sparql list all graphs
SQL
0 vote211 views1 answer
Psql no such file or directory
SQL
2 votes242 views2 answers
Storing timezones in postgres
SQL
1 vote263 views5 answers
Postgresql difference between two dates in days
SQL
3 votes210 views1 answer
Get all elements sql
SQL

Share