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

Is stored procedure faster than query?

1021


What type of database is sql?

1068


What programs use sql?

1088


What is a heap in sql?

1148


How are sql commands classified?

1143


How to create your own reports in sql developer?

1066


Is it possible to create the following trigger: before or after update trigger for each row?

1354


Why do we go for stored procedures?

1126


what is a field in a database ? : Sql dba

1099


how to fetch common records from two tables? : Sql dba

1253


explain the advantages and disadvantages of stored procedure? : Sql dba

1067


What if we write return in procedure?

1513


how to create a new table by selecting rows from another table in mysql? : Sql dba

1168


What can you do with pl sql?

1145


what are the properties and different types of sub-queries? : Sql dba

1077