Write a query to find second highest salary of an employee.
Answer Posted / senorita
select ename,salary from (select rownum,ename,salary from
emp
order by desc) where rownum=2;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is the difference between primary key and unique key? : Sql dba
How do you update f as m and m as f from the below table testtable?
What is the default isolation level in sql server? : Transact sql
Explain what is a database?
What is the difference between sql and isql*plus?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What are conditional predicates?
How do you exit in sql?
Which is faster joins or subqueries?
What are tuples in sql?
Show code of a cursor for loop.
How do I run sql profiler?
What is difference between sql and mysql?
How do I trace sql profiler?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?