how to get second highest salary in SQL(as/4000
Answers were Sorted based on User's Feedback
Answer / siva kumar yachamaneni
select max(salary) from Employee where salary<(SELECT
max(salary) from Employee)
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / prabir
Select * From employee emp1 Where 2 = (Select
Count(Distinct(emp1.salary)) From employee emp2 Where
emp2.salary > emp1.salary)
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / shasi
select sal from emp a where &n=(select count(sal) from emp
b where a.sal>=b.sal)
First u enter 1 means 1st highest sal.then enter2 2nd
highest sal
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / ashish raut
for 2nd highest price..............
SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails)
for 3rd highest Price........
SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails
where price<(SELECT max(Price)as MaxPrice from OrderDetails))
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / praveen
select * from emp where max(sal)
where rownow=2
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / apurva
Select *
From (
Select *
From (select * from emp order by sal desc)
Where rownum < 3 order by sal) ---> n+1 for example for
secound you should use 3
Where rownum < 2
Is This Answer Correct ? | 4 Yes | 7 No |
Answer / sachin bhalsinge
select * from (select salary from employees order by salary
desc)where rownum=2;
Is This Answer Correct ? | 5 Yes | 11 No |
Answer / ramesh.p
Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;
Is This Answer Correct ? | 10 Yes | 19 No |
Answer / siddhartha
select sal, ename from employee where ROWNUM = 2 order by
sal;
Is This Answer Correct ? | 12 Yes | 36 No |
Is left join same as join?
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
what is online transaction processing (oltp)? : Sql dba
difference between oracle 8i and oracle 9i
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Does it possible to pass object (or) table as an argument to a remote procedure?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
what is column? : Sql dba
What are different clauses used in sql?
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
how many columns can be used for creating index? : Sql dba