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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

find the second highest salary of the emp table

Question Posted / naresh

Answer Posted / naresh

Here it is the simple solution.

Select Salary from (Select Salary, Rownum from Employee
order by Salary desc) where rownum=2

Should Work
Cheers!
Naresh

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the attributes of cursor?

1015

How many categories of data types in oracle?

993

How to test null values?

1061

Explain oracle instance.

1128

What is raw datatype in oracle?

1086

Can the query output be sorted by multiple columns in oracle?

959

what is the scripts in data base?

2099

How to insert a record into a table?

1038

How to install oracle database 10g xe?

980

What is an oracle cursor variable?

1029

How to rename a tablespace in oracle?

1056

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2224

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2272

Design database draw er diagram for a certain scenario ?

4551

What is a package ? What are the advantages of package ?

1054