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

find the third highest salary?

Answer Posted / imran ansari

find n th highest salary replace n with 1,2,3....to find second,third,fourth........sal
SELECT sal from emp order by sal desc limit 2,1

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you pass hints to the sql processor?

967


explain about mysql and its features. : Sql dba

1002


What is varchar example?

1012


Do stored procedures prevent sql injection?

953


What are the different types of tables in sql?

972


Could you please provide oca (oracle 10g) dumps for my certification ?

5125


Which join is default?

935


how to write date and time literals? : Sql dba

945


What are the features of pl sql?

1047


What is form and report?

960


How do I get sql certification?

953


How do I find duplicates in the same column?

1056


What is cross join example?

971


What is difference between inner join and self join?

1068


Is drop table faster than truncate?

972