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 can we find duplicate records in a table?
what is a database lock ? : Sql dba
What is int identity in sql?
What will you get by the cursor attribute sql%notfound?
How can I delete duplicate rows?
Why plvtab is considered as the easiest way to access the pl/sql table?
Difference between truncate, delete and drop commands?
What is normalization? How many normalization forms are there?
What is pl sql package?
What are the advantages of pl sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What are its different types of dbms?
what are the difference between clustered and a non-clustered index? : Sql dba
Why is a primary key important?
how to drop an existing index in mysql? : Sql dba