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 / jithu

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?    9 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bulk collect in pl sql?

1158


Name the operator which is used in the query for pattern matching?

1004


What are the benefits of pl/sql packages?

1161


what are the differences between require and include, include_once and require_once? : Sql dba

1071


what is a database? : Sql dba

1241


Is crud a cuss word?

1074


What are records give examples?

1054


What is right join sql?

1013


What is a design view?

978


Do we need commit after truncate?

1136


Explain what is a view?

1117


What is the basic structure of an sql?

1159


How to test for null values?

1098


What is coalesce in sql?

1132


Which command is used to delete a package?

1236