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 / muhammed zaheer

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?    86 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What steps server process has to take to execute an update statement?

977


explain advantages of myisam over innodb? : Sql dba

1069


What is int identity in sql?

1146


What is the use of & in pl sql?

1046


How to use transactions efficiently : transact sql

1060


Which is better cte or subquery?

1030


How long it takes to learn pl sql?

1014


Can a foreign key be null?

1093


how can we optimize or increase the speed of a mysql select query? : Sql dba

948


How can a function retun more than one value in oracle with proper example?

1074


What is difference between nchar and nvarchar?

1029


what is 'mysqldump'? : Sql dba

1111


What is the importance of sqlcode and sqlerrm?

1356


how can we destroy the session, how can we unset the variable of a session? : Sql dba

1003


Give the order of sql select?

1137