Write a query to find second highest salary of an employee.
Answer Posted / vamana murthy
select ename,salary from emp
where rownum=2
order by salary desc
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
what is the syntax used for partition in tsql? : Transact sql
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How does sql profiler work?
What does sql stand for?
how to delete an existing column in a table? : Sql dba
Define implicit and explicit cursors.
What is %rowtype in pl sql?
Explain isolation levels. : Transact sql
What is difference between ms sql and mysql?
What is cross join sql?
how to convert character strings to numeric values? : Sql dba
What is nvarchar max in sql?
What is the least restrictive isolation level? : Transact sql
How do I view output in sql developer?
What is varchar data type in sql?