/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 vote186 views1 answer
Write SQL in ruby on rails
SQL
0 vote174 views1 answer
Mysql row generator
SQL
3 votes215 views1 answer
Oracle list invalid password logon denied
SQL
0 vote158 views1 answer
Check psql validity function
SQL
0 vote192 views1 answer
Oracle winter time change
SQL
0 vote139 views1 answer
Django how to get query result count
SQL
0 vote190 views1 answer
QUERY JPQL
SQL
0 vote191 views1 answer
Compare subqueries oracle
SQL
0 vote177 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
2 votes176 views1 answer
Oracle list grants on package
SQL

Share