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 / swapnil tikale

Select top 1 salary from (select distinct top 2 salary from employee order by salary desc) as sal order by salary ;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I call a procedure inside a function?

1076


What are the different dml commands in sql?

1249


What is trigger in pl sql?

1050


What is thread join () in threading?

1057


Can you load data into multiple tables at once? : aql loader

1120


What is the difference between left join and right join?

990


Can unique keys be null?

949


Why do we use function in pl sql?

1114


What is a table partition?

1208


Can we call procedure in select statement?

1113


What are joins in sql?

1110


what are tables and fields? : Sql dba

1105


how many ways to get the current time? : Sql dba

1048


how is exception handling handled in mysql? : Sql dba

1132


Enlist the characteristics of pl/sql?

1846