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

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

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 sql data types?

1032


Does mysql_real_escape_string prevent sql injection?

953


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1074


Define commit, rollback and savepoint?

1033


how to decrement dates by 1 in mysql? : Sql dba

1020


how to return query output in html format? : Sql dba

1079


What is the purpose of normalization?

1047


What is difference between inner join and cross join?

971


Can we create index on primary key?

973


What is the purpose of my sql?

953


Can ddl statements be used in pl/sql?

1145


What is the clause we need to add in function body to return variable?

1013


What is the primary use of normalization?

1006


What is sql*plus?

1084


what are all different types of collation sensitivity? : Sql dba

982