Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SELECT *
FROM
(SELECT *
RANK() OVER (PARTITION BY IS ORDER BY CATEGROY DESC) RNK
FROM table_name
WHERE date = '31-OCT-17'
AND CATEGROY IN ('S','Special')
AND ID IN ('284','315')
)
WHERE RNK=1;