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

select sal from emp where rownum=2 order by sal desc;

Is This Answer Correct ?    6 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pl/sql table? Why is it used?

1035


What is sql trigger example?

1053


What is a sql driver?

995


Why do we use cursors?

984


What are the different types of a subquery?

1044


What is the primary use of normalization?

1000


How can a function retun more than one value in oracle with proper example?

1073


What is the difference between clustered and non-clustered indexes?

1085


What is the use of double ampersand (&&) in sql queries? Give an example

1139


How to install oracle sql developer?

1042


What is the current version of postgresql?

1060


What is data definition language?

1088


What is an exception in pl/sql?

1084


What are the events on which a database trigger can be based?

1180


Does pdo prevent sql injection?

931