how to find the second highest salary from emp table?
Answer Posted / moharaj m
select max(salary) from emp where salary < (select max
(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is it possible to read/write files to-and-from PL/SQL?
How does postgresql compare to oracle/db2/ms sql server/informix?
What are the popular database management systems in the it industry?
How do I filter in sql profiler?
What is nvl?
What view means?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Show code of a cursor for loop.
How do you optimize a stored procedure in sql?
What is a constraint?
Can you join views in sql?
How subquery works in sql?
What is the use of sqlerrd 3?
Which command is used to delete a package?
How to write a query to show the details of a student from students table whose