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

select max(salary) from employee where salary!=(select max
(salary) from employee);

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to update views?

919


What are some predefined exceptions in pl/sql?

1067


what are the properties and different types of sub-queries? : Sql dba

970


How do you declare a constant?

911


which operator is used in query for pattern matching? : Sql dba

950


How do I find duplicates in a single column in sql?

954


What is trigger in sql? Explain

945


What are dml commands?

943


How do you explain an index number?

1024


Does sap use sql?

933


What are sql procedures?

967


how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

919


What is difference sql and mysql?

943


how to rename an existing table in mysql? : Sql dba

1006


What is the plv (pl/vision) package offers?

981