how to get second highest salary in SQL(as/4000
Answer Posted / c srirammulu
select * from emp a where &n=(select count(distinct (sal))
from emp f where a.sal<f.sal)
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sql rowcount?
Is left join faster than join?
what is the syntax used for partition in tsql? : Transact sql
What does select top 1 do in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is a temporal data type?
what are the difference between clustered and a non-clustered index? : Sql dba
Enlist the data types that can be used in pl/sql?
What is auto increment in sql?
What is a nested table in word?
What is aggregate function in sql?
What makes a good primary key?
Why do you partition data?
What is the difference between local variables and global variables?
When are we going to use truncate and delete?