0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

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 ID, rank, Name
--FROM A

SELECT MAX("rank")
FROM A
GROUP BY ID


/*
SELECT *
FROM B
LEFT JOIN A
ON B.ID = A.ID
AND A.RANK = (SELECT MAX(A.RANK) 
              FROM A
              WHERE A.ID = B.ID
              )
*/

fork query

edited jul 26 19 anonymous

created feb 27 12 conradfrix