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 4th max salary

Answer Posted / mujahid

Simple one is i think:
Select min(sal) from (select sal from emp order by sal desc LIMIT 4);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is compute?

1016


What is varchar example?

975


What is clause in sql?

1056


how to dump a table to a file with 'mysqldump'? : Sql dba

983


What are the triggers associated with image items?

1000


Is natural join and inner join same?

853


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3518


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1017


How we can update the view?

1007


How to load data with sql*loader?

1000


Explain the rollback statement?

964


Define SQL and state the differences between SQL and other conventional programming Languages?

1144


What is Difference Between Unique and Primary Key Constraints?

1060


Which join is like an inner join?

954


Can we update views in sql?

899