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 / chaitanya pathak

select max(salary) from employee
where salary<(select max(salary) from employee)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between function, procedure and package in pl/sql?

1138


where are cookies actually stored on the hard disk? : Sql dba

977


What are the types of views in sql?

1041


What does <> sql mean?

989


who introduced sql?

950


How to load data with sql*loader?

1000


What does closing a cursor do?

1247


Why query optimization is needed?

865


How can I speed up sql query?

907


How many columns should be in an index?

904


Why stored procedure is better than query?

887


Why do we use procedures?

914


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

987


What is recursive join in sql?

948


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

947