Answer / p

select ename from emp where esal=(select max(esal) from emp
where esal<(select max(esal) from emp));

Answer / satish

select e1.* from emp where 1=(select e2.sal from emp e2
where e2.sal>e1.sal)

Answer / kapil deep

SELECT * FROM (SELECT * FROM emp_t WHERE ROWNUM < 3 ORDER
BY salary) WHERE ROWNUM < 2

above query work fine for oracle.

Taking 3 as N give u 3-1=2 i.e 2nd highest
4-1=3 gives u 3rd highest

Answer / deepak falke

3rd highest sal from account :

SELECT TOP 1 Sal FROM account WHERE Sal IN
(SELECT distinct TOP 3 Sal FROM account ORDER BY Sal DESC)
order by sal

Answer / vidhya

select max(column name) from table_name where((select max
(column name) from table_name Order by salary Desc) set
difference (select max(column name))

Answer / krishna kishore

SELECT TOP 1 Salary FROM Employee WHERE Salary IN
(SELECT TOP 2 Salary FROM Employee ORDER BY Salary DESC)

I think this would be the simplest way and high performance
query.

waiting for the comments !!!

Answer / muralidhara(minchu)

Select * from epm A where &(n-1)=(select count(*) from emp
B where A.sal < B.sal);

Try this it will work,this will give nth salary ie if u
enter 2 this will give second highest sal

Answer / sridhar

Its real simple. Suppose your employees are in a table
called by the same name, and the salaries in a column named
salaries). Lets See te case in which we want the 3 greatest
salaries. Then you Query:

SELECT employees.salary
FROM employees
ORDER BY employees.salary desc
LIMIT 3;

If you want the biggest 5 salaries, you put LIMIT 5, and so on….

Answer / krishna

select sal from empa where 1=(select count of sal from emp
b)where a.sal<b.sal

Answer / gokulapriya

select * from employee where salary < (select max(salary)
from employee)
(i have written as sub query)
is this right

What is a ‘test plan’? What is a ‘test case’?

0 Answers  

Tell me what is an absolute xpath?

0 Answers  

How you will evaluate the tool for test automation?

1 Answers  

Why we use Junit and Jmeter? Suggest some sites where we can get more information on these two Tools?

2 Answers  

Any quality test-tracking tool which has live & automated dashboards so that the entire team is updated at any given point of time?

1 Answers  

What kinds of annotations are used in testng?

0 Answers  

List of Test Management Tools??Is Quality Center Test Management tools

0 Answers  

pls suggest me a good institute for loadrunner in hyderabad also what about a practice project?

43 Answers  

What is self-referencing constraint in mainframe development?

0 Answers  

3. Generally what type of bugs we are finding in a project give some examples?

2 Answers   Eka Software,

How to write output data to a file (txt,csv,excel) using Test complete automation tool?

2 Answers  

whether flash selenium supports to test Gaming application? like follows: identifying the images, dynamic animations, Dynamic value changes field and win conditions etcc..,

0 Answers