how to calcuate the second highest salary of he employee
Answer Posted / sachin s. patil
SELECT SAL FROM
(SELECT ROWNUM DD, M.* FROM
(SELECT SAL FROM EMP order by sal desc )M)
WHERE DD=2/***HERE U CAN ADD ANY NUMBER (WHERE I PUT 2)
, U WILL GET HEIGHEST SALARY THAT POSITION *******/
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can I speed up sql query?
What is java sql driver?
Why is sql*loader direct path so fast?
Which sql statement is used to delete data from a database?
What is the difference between instead of trigger and after trigger?
How does cross join work?
How many joins can you have in sql?
What is the difference between inner join and left join?
Which are the different types of indexes in sql?
Can we write ddl statements in functions?
What are inner outer left and right joins in sql?
Describe types of sql statements?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is dcl in sql?
What is localdb mssqllocaldb?