Answer / a.jyothsna

select a.sal
from emp a
where 3=(select distinct(count(b.sal))
from emp b
where a.sal<=b.sal)

Answer / kaushal kassi

select distinct a.sal
from employee a
where 3=(select count(distinct b.sal)
from employee b
where a.sal<=b.sal)

Answer / srikanth

select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)

Answer / karna

Hi Friends,

to get the nth highest value of a column in a table,please
use the below simple query

select min(column) from table where column in(select top n
column from table)

any queries,mail me at karun84@gmail.com

Answer / karna

Hi Friends,

sorry,last answer was wrong.
I have changed the query,check now

to get the nth highest value of a column in a table,please
use the below simple query

select min(column) from table where column in(select top n
column from table order by desc)

any queries,mail me at karun84@gmail.com

Answer / surendra kumar dattatrey

Select * from Emp where Salary =
(Select max(Salary) from Emp where Salary <
(Select max(Salary) from Emp where Salary <
(Select max(Salary) from Emp where Salary <.....N))))

Answer / abhay

select distinct(sal) from emp a where 3=(select
count(distinct(sal) from emp b where a.sal<=b.sal);


somebody tell me he logic....!

Answer / sachin

select distinct(sal) from employee order by sal desc limit 2,1;

Answer / anjali

select min(column_name) from table where column in(select
top n
column_name from table order by column_name desc)

Answer / amit singh

Empsal table data
700
500
100
900
400
200
600
750


query to find second highest salary from table Empsal

mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
(select max(salary) from Empsal));

Output=750



query to find third highest salary from table Empsal


mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
>(select max(e1.salary) from Empsal e1
>where e1.salary IN(
>select e2.salary from Empsal e2 where
>e2.salary<(select max(salary) from Empsal))));
Output=700

RUN THE QUERY THEN ARG
amitsing2008@gmail.com(amit is back)

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

Differentiate between % rowtype and type record.

0 Answers  

Which is faster view or stored procedure?

0 Answers  

Does a user_objects view have an entry for a trigger?

0 Answers  

What is cursor explain with example?

0 Answers  

What does select top 1 do in sql?

0 Answers  

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

How to convert ms-excel file to oracle table?

2 Answers  

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

What is assignment operator in pl sql?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,