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 find the second highest salary from emp table?

Answer Posted / raghavendraprasad

select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);

Is This Answer Correct ?    7 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql microsoft?

977


How many disk partitions should I have?

941


Explain the the delete statements in sql?

977


how to create a new view in mysql? : Sql dba

893


How to run sql*plus commands in sql developer?

1085


Describe sql comments?

960


What does := mean in pl sql?

990


What does the hierarchical profiler does?

1003


Do we need commit after truncate?

1030


What is sql and how does it work?

1087


What are joins in sql?

956


What are pl sql procedures?

961


what are the nonstandard string types? : Sql dba

1083


Can procedure in package be overloaded?

1029


what is the difference between char_length and length? : Sql dba

990