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 is rollback? : Sql dba

1115


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2501


What is multiple columns?

1071


What is dml and ddl?

960


What is pl/sql table? Why is it used?

1049


How do I start sql from command line?

1027


What are the uses of merge?

1167


what is cursor. write example of it. What are the attributes of cursor.

1395


what is the difference between truncate and drop statements? : Sql dba

1127


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2226


What is a unique key and primary key and foreign key?

969


Is json a nosql?

984


Which nosql database is best?

982


How to add new employee details in an employee_details table with the following details

1091


What are types of joins?

967