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...


how to check the 3rd max salary from an employee table?

Answers were Sorted based on User's Feedback



how to check the 3rd max salary from an employee table?..

Answer / manish_patil

select sal from emp_sal where rownum = 3 order by sal desc

Is This Answer Correct ?    6 Yes 9 No

how to check the 3rd max salary from an employee table?..

Answer / tushar

select max(sal) from ( select sal from emp group by sal order by sal) where rownum<4;

Is This Answer Correct ?    0 Yes 3 No

how to check the 3rd max salary from an employee table?..

Answer / nagendra

select min(sal) from emp where sal in( select top 3 sal
from emp order by sal desc)

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More SQL PLSQL Interview Questions

What programs use sql?

1 Answers  


How do you explain an index number?

1 Answers  


What does trigger mean in psychology?

1 Answers  


Can we change the table name in sql?

1 Answers  


Can you have a foreign key without a primary key?

1 Answers  


how will i became good database developer?

1 Answers  


How do I edit a stored procedure?

1 Answers  


Can we join tables without foreign key?

1 Answers  


Can we debug stored procedure?

1 Answers  


Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,


What is the sql case statement?

1 Answers  


What are the topics in pl sql?

1 Answers  


Categories