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

select max(salary)
from Emp
where rownum < 2;

Is This Answer Correct ?    3 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to drop an existing table in mysql? : Sql dba

1092


what are date and time data types? : Sql dba

1028


How to read xml file in oracle pl sql?

948


Which query operators in sql is used for pattern matching?

1011


How to order siblings in oracle hierarchy queries?

1111


How to fix oracle error ora-00942: table or view does not exist

1084


How long will it take to learn pl sql?

981


What is the current version of sql?

1069


In what condition is it good to disable a trigger?

1071


State few characteristics of pl/sql?

1023


What is native sql query?

1076


What is user defined functions?

1029


How do you declare a variable in pl sql?

1071


Which nosql database is best?

1025


Does pdo prevent sql injection?

990