Monday, May 17

టాప్ సాలరీస్ అఫ్ ఏమ్ప్లోయీ

SELECT TOP 1 flatCost FROM
(SELECT DISTINCT TOP 4 flatCost FROM jpFlats ORDER BY flatCost DESC) jpFlats
ORDER BY flatCost

SELECT MAx(flatCost) FROM jpFlats
WHERE flatCost<(SELECT Max(flatCost) FROM jpFlats)

No comments: