/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

3 votes151 views1 answer
Set default today mysql
SQL
0 vote195 views1 answer
Mac os zsh: command not found: mysql
SQL
2 votes127 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote90 views2 answers
Avg() sql
SQL
34 votes155 views6 answers
Install mysql client ubuntu
SQL
42 votes201 views6 answers
Install beautifulsoup
SQL
0 vote120 views2 answers
How to get json data mysql
SQL
0 vote154 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
7 votes169 views2 answers
Oracle foreign key reference table
SQL
6 votes140 views3 answers
Date_trunc postgres
SQL

Share