Answer / siva kumar yachamaneni

select max(salary) from Employee where salary<(SELECT
max(salary) from Employee)

Answer / prabir

Select * From employee emp1 Where 2 = (Select
Count(Distinct(emp1.salary)) From employee emp2 Where
emp2.salary > emp1.salary)

Answer / shasi

select sal from emp a where &n=(select count(sal) from emp
b where a.sal>=b.sal)
First u enter 1 means 1st highest sal.then enter2 2nd
highest sal

Answer / ashish raut

for 2nd highest price..............

SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails)

for 3rd highest Price........

SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails
where price<(SELECT max(Price)as MaxPrice from OrderDetails))

Answer / praveen

select * from emp where max(sal)
where rownow=2

Answer / apurva

Select *
From (
Select *
From (select * from emp order by sal desc)
Where rownum < 3 order by sal) ---> n+1 for example for
secound you should use 3
Where rownum < 2

Answer / sachin bhalsinge

select * from (select salary from employees order by salary
desc)where rownum=2;

Answer / ramesh.p

Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;

Answer / siddhartha

select sal, ename from employee where ROWNUM = 2 order by
sal;

Why use truncate instead of delete?

0 Answers  

What is data control language (dcl)?

0 Answers  

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

How many primary keys can a table have?

0 Answers  

What are all the common sql functions?

0 Answers  

find the third highest salary?

23 Answers  

What is sql procedures and functions?

0 Answers  

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

Is postgresql a server?

0 Answers  

What does pragma mean?

0 Answers  

Can a foreign key have a different name?

0 Answers  

What is the Subquery?

4 Answers