SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY SALARIUL DESC) AS rownumber,
   ID_ANGAJAT,SALARIUL
  FROM ANGAJATI
)
WHERE rownumber = 10;