Write a query to find second highest salary of an employee.
Answers were Sorted based on User's Feedback
Answer / ravi
I write this query and it run !!
SELECT max(salary) FROM Employee WHERE Employee.salary <
(SELECT max(salary) FROM Employee)
Plz reply if anyone having generic answer. :-)
Thanks
Is This Answer Correct ? | 313 Yes | 56 No |
Answer / pradeep kumar
Select max(salary) from emp where salary NOT IN (Select max
(salary) from emp)
Is This Answer Correct ? | 95 Yes | 16 No |
Answer / vittal
select max(sal)from emp e1 where 2<=(select count(*) from
emp e2 where e1.sal <= e2.sal);
Is This Answer Correct ? | 66 Yes | 38 No |
Answer / upali tejale
Select max(salary) from employee where salary NOT IN
(Select max(salary) from employee)
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / priyanshu
select First_Name,Salary from employees where salary in
( select max(salary) from employees
where salary < ( select max(salary) from employees) ),
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / sweety spear
select *from emp e1 where &n =(select count(*) from emp
where sal >= e1.sal);
Is This Answer Correct ? | 13 Yes | 3 No |
Answer / lokesh kanithi
Select * from emp e where 2=(select count(Distinct(esal))
from emp where e.esal<=emp.esal)
Is This Answer Correct ? | 27 Yes | 22 No |
Answer / rajkumar mandala
select sal from
(select rank() OVER (order by sal desc) sno ,sal from emp)
y
where sno= n
here
y : is the alias name for (select rank() OVER (order by sal
desc) sno ,sal from emp)
n : is the number ie if u want second highest sal then 'n'
value will be 2. for third highest n= 3...
Is This Answer Correct ? | 7 Yes | 2 No |
Which institute is good for testing tools course in HYD?
you have any interaction with clients?
Tell me how can you switch back from a frame?
How will you choose a tool for test automation?
Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai
Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?
WHAT WE CAN NOT DO WITH QTP? GIVE 5 POINTS.(EXCEPT PERFOMANCE)
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
What testing activities you may want to automate?
Describe some problem that you had with automating testing tool.
Does automation replace manual testing?
What are the important operations in database testing?