Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
Once check and post one question only once. Other wise all of us are wasting time by opening duplicate queries. MODERATOR may not alert and aware about the things like duplicates. Please delete duplicates frequently and faciliate users.
If any one first opens this query for answer i dont want to disappoint them. So here is your answer...
SELECT SAL FROM TABLEA A WHERE N=(SELECT COUNT(DISTINT *) FROM TABLEA B WHERE A.SAL<=B.SAL);