T devillers wrote:These are given column names
" EMPNO" , "ENAME ", " JOB", " MANAGER"," HIREDATE" ,"SALARY", "COMMISSION", "DEPTNO" name under "EMPLOYEE' table , i have to find first three maximum salary ?? Please assume oracle db . I know how to find max salary but not first 3 max sal .
To get max salary, the easiest query, as i am sure you know, uses MAX(). To get more than one, one easy way is to use ORDER BY, while returning ROWNUM. Then a second query limits based on ROWNUM. (You can also use ROW_NUMBER() OVER(ORDER BY).)
To start you off, try something like this: