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 |
Write a short compiled module which selects random numbers?
3. Generally what type of bugs we are finding in a project give some examples?
What is functional and regression testing?
Bug report formate in bugzilla
How to download QTP 9.5 Trail version? please explain the complete process?
Tell me how can the user get a text of a web element?
how many steps in functional testing?
What are the limitations of automating software testing?
how to re-install QTP 11.0 trial version
In Selenium how a test suit is run and report is generated.
Mention a few good practices while performing automation testing.
Give some examples for defect management tools?