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 / parvezkhan pathan

select max(salary) from emp where salary not in(select
max(salary) from emp);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you have more than one trigger on a table?

941


What do you mean by stored procedures? How do we use it?

931


Are there any features that are decommissioned in 11g that are not present in 11g?

2069


What is user defined functions?

918


Is a table valued function object?

962


How can one get sql*loader to commit only at the end of the load file? : aql loader

1005


define sql insert statement ? : Sql dba

976


how to include numeric values in sql statements? : Sql dba

1041


How do I start sql profiler?

943


How do I debug a stored procedure?

1042


What does over partition by mean in sql?

923


What are sql triggers used for?

958


What do you mean by stored procedures?

953


What is a common use of group by in sql?

997


how to start mysql server? : Sql dba

1147