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

how to get second highest sal of emp table

Question Posted / anilchandu

Answer Posted / anilchandu

Select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal)


where x,y are alias names.

If you want 3rd heighest salary then just replace 2 by 3

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to insert multiple rows with one insert statement in oracle?

1059

ABOUT IDENTITY?

2033

How to find out what oracle odbc drivers are installed?

1024

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4151

What is dynamic proxy?

988

Explain oracle instance.

1157

What are the differences between char and nchar in oracle?

1066

Why does for update in oracle 8 cause an ora-01002 error?

983

How to set a transaction to be read only in oracle?

1076

What are nested tables?

1150

What is a trigger and what are its types?

1198

What is open database communication (odbc) in oracle?

987

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1718

Explain integrity constraint?

1142

How to best split csv strings in oracle 9i?

1023