how to get second highest salary in SQL(as/4000
Answer Posted / devi
select sal from (select sal,rank() over(order by sal desc)
as rank from emp) where rank>1 and rank<3
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to run pl sql program in mysql?
what is the difference between truncate and delete statement? : Transact sql
Explain the methods used to protect source code of pl/sql.
Does a user_objects view have an entry for a trigger?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is set serveroutput on in pl sql?
What is an emotional trigger?
How many databases can sql express handle?
What is cursor and why it is required?
What does over partition by mean in sql?
what are all the common sql function? : Sql dba
What are tables in sql?
How exception is different from error?
Explain 3 basic parts of a trigger.
How do I write a cron which will run a sql query and mail the results to agroup?