Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Write a query to find second highest salary of an employee.

Answers were Sorted based on User's Feedback



Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

Answer / dharmaraj

SELECT max(salary) as salary FROM Employee WHERE salary <
(SELECT max(salary) FROM Employee)

Is This Answer Correct ?    67 Yes 9 No

Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

Answer / murlidhar

select * from emp A where 2=(select count(*) from emp B
where A.sal < B.sal)

Is This Answer Correct ?    41 Yes 36 No

Write a query to find second highest salary of an employee. ..

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

Write a query to find second highest salary of an employee. ..

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

Post New Answer

More Automation Testing AllOther Interview Questions

We have a testing assignment should be test in very short span.Do you think automated tests are the best solution for this type of scenario?

3 Answers  


When you will not automate testing?

0 Answers  


Hi There...I am guy from Mumbai working as a Software Tester (Manual). I really want to learn automation with live projects. Could anyone help me to learn automation or give tutions. I do not like the way the Software testing Institute provides training. Please can anyone help me out. And also I want to appear for ISTQB exam...please help me out....Thanks in advance.. My ID is amaan_sbp@yahoo.com amaanactually@gmail.com Phone no: 9323543045

2 Answers  


why we cannot apply check points in compile modules?

0 Answers  


how is mind q venkat training in testing for weekend or general batches.and any other good institutes in ameerpet

1 Answers  


Give some examples for test management tools?

0 Answers  


How could the web element attributes be inspected in order to use them in different locators?

0 Answers  


Please explain how to perform load-testing?

0 Answers  


Describe any bug you remember?

1 Answers   Ordain Solutions,


Tell us what automation tools could be used for post-release validation with continuous integration?

0 Answers  


Simplify the term defect severity.

0 Answers  


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?

1 Answers  


Categories