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 get second highest salary from a table

Answer Posted / saiz

select min(salary)
from emp
where salary in ( select top 2 salary
from emp
order by salary desc);

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the three pl sql block types?

1049


How many triggers can be applied on a table?

988


Is it possible for a table to have more than one foreign key?

1082


how to use case expression? : Sql dba

1079


What is the difference between union and union all command?

1151


How is sql used in oracle?

1037


Define tables and fields in a database

1177


What is the difference between inner join and natural join?

1056


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1123


How can get second highest salary in sql?

1025


What is the difference between clustered and non-clustered indexes?

1129


What are the different types of dbmss?

1054


What is attribute indicator in pl sql?

1068


What is the difference among union, minus and intersect?

1049


What is indexing in sql and its types?

1135