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 find second highest salary of an employee.

Answer Posted / monika

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

Is This Answer Correct ?    8 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use myisamchk to check or repair myisam tables? : Sql dba

956


What is cascade in sql?

945


What is union and union all keyword in sql and what are their differences?

1083


what are properties of a transaction? : Sql dba

1076


How do I make sql search faster?

981


How do I access sql anywhere database?

950


What is using in sql?

1060


What is the difference between the sql*loader and import utilities? : aql loader

1013


what tools available for managing mysql server? : Sql dba

1062


What do you mean by “trigger” in sql?

1054


What is delimiter in pl sql?

1034


Differentiate between sga and pga.

1141


Explain the difference between triggers and constraints?

961


How many aggregate functions are available there in sql?

965


What is compiled query?

1012