0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

WITH A As (
SELECT 1 as ID, 100 rank , 'Name1' as Name
UNION SELECT 1,    45,  'Name2'
UNION SELECT 2,    60,  'Name3'
UNION SELECT 2,    42,  'Name4'
UNION SELECT 2,    88,  'Name5' )
, B AS (
SELECT 1 as ID, 'fn1' as FileName
UNION SELECT 2  , 'fn2')

SELECT DISTINCT a1.name
FROM a a1
LEFT JOIN a a2
  ON a2.id = a1.id
  AND a2.rank > a1.rank
WHERE a2.id IS NULL

fork query

edited oct 3 23 anonymous

created feb 27 12 conradfrix