Write a query to find second highest salary of an employee.
Answers were Sorted based on User's Feedback
Answer / rajkumar mandala
select sal from
(select sal,(row_number() over (order by sal)) N from emp ) y where N= {value}
Replace {value} value with required highest value.
ie, 2 for 2nd highest
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / aj
select * from emp A where 1=(select count(*) from emp B
where A.SALARY < B.SALARY)
Is This Answer Correct ? | 12 Yes | 9 No |
Answer / girase hitendrasing a.
select * from Employees where Salary in (select top 1
salary from (select distinct top 2 salary from employees
order by salary desc) order by salary asc)
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / bhaskar reddy thamma
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / n.tejaswi
Select Empname
from emp LIMIT 2
orderby empsal;
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / khurram
The Simplest, easy, Understandable solution is
select max(sal) from emp where
sal not in
(select distinct Top 1 sal from emp order by sal desc)
Go Check Out for yourself
[replace "top 1" by "top 2" to get 3rd highest sal]
[replace "top 1" by "top 3" to get 4th highest sal] so on..
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ujwlala
select max(salary) from employee where salary<>(select
max(salary) from emp)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / satish
select e1.* from emp e1 where 1=(select count(distinct
e2.sal) from emp e2 where e2.sal>e1.sal)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ashutosh singh
select distinct(a.Sal) from emp a where &n=(select
count(distinct(b.Sal)) from emp b where b.Sal<a.Sal)
Is This Answer Correct ? | 2 Yes | 1 No |
What is test driven development?
diff b/w DBMS & RDBMS?
69 Answers BirlaSoft, Infosys, Mind Tree, TCS,
If testing is done using white box testing,then what is the need of using Black box testing again? I mean when unit testing and Integration testing is done at Coding level, what is the need of testing again at testing level?
Explain me what kinds of annotations are used in testng?
Does Microsoft Corporation, Sun Microsystems possesing any maturity levels?if yes, what is that level?
Which of the Test cases can be automated? can anybody tell me with an example.
If automating - what is your process for determining what to automate and in what order?
Do you know what is a xpath?
default time for executing 1000 lines of script in winrunner and also in qtp.
How can the user get a text of a web element?
Tell us how could you explain the main difference between webdriver and rc?
How t o create Libreary files on QTP