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 in SQL(as/4000

Answer Posted / deepak

select max(sal) from emp where sal!=(select max(sal) from emp);

Is This Answer Correct ?    12 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1227


How do I run a sql trace?

963


What is bulk collect in pl sql?

1092


How is data stored in sql?

1063


What is the usage of nvl function?

1040


What do you understand by pl/sql records?

1022


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1039


what are null values? : Sql dba

959


Does mysql support pl sql?

1176


What are properties of the transaction?

998


What is the most restrictive isolation level? : Transact sql

1085


how to create a table index in mysql? : Sql dba

1062


what is union? : Sql dba

1031


Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1210


Mention what plvcmt and plvrb does in pl/sql?

1143