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...

Write a query to get 2nd maximum salary in an employee table ?

Answer Posted / baburav zore

select max(sal) from employee where sal<(select sal from employee);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the differences among rownum, rank and dense_rank? : Sql dba

1047


What are the different types of triggers?

1144


What is oracle sql developer?

1075


i have some prob lem to tell me about my self in interview first round ...

2170


How to start oracle sql developer?

1049


What are character functions in sql?

949


explain advantages of myisam over innodb? : Sql dba

1077


What is difference between ms sql and mysql?

976


How would you pass hints to the sql processor?

996


Does truncate free space?

1020


Can cursors be part of a trigger body?

1648


Is sqlexception checked or unchecked?

975


what are different types of collation sensitivity? : Sql dba

1079


how do you know if your mysql server is alive? : Sql dba

1089


what is 'mysqlcheck'? : Sql dba

1021