how to find the second highest salary from emp table?
Answer Posted / nitin
SQL> select emp_sal from (select emp_sal from nitin order
by emp_sal desc) group by rownum,emp_sal
having rownum=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is cte sql?
Why is the cursor important?
What are stuff and replace function?
How do you truncate?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How is data stored in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is the difference among union, minus and intersect?
What is the difference between local and global temporary table?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is sql basics?
What do you mean by dbms? What are its different types?
How many postgresql users are there, worldwide?
How delete all data from table in sql?
how to include character strings in sql statements? : Sql dba