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 out the second highest salary?

Question Posted / naveen

Answer Posted / naveen

selec * from emp e1 (n-1)=(select count(distinct(sal) from
emp e2 where e1.sal<=e2.sal))

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What language does oracle use?

1164

What is oracle open database communication (odbc)?

1082

WHAT IS ecc 6.0

2199

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1981

How to Truncate Table in Oracle

1210

What is flashback in Oracle?

1060

How to pass a parameter to a cursor in oracle?

1225

What are data pump export and import modes?

1110

How to convert a string to a date in oracle database?

1091

Can we store images in oracle database?

1063

What is java oracle used for?

1075

How to retrieve values from data fields in record variables?

1168

Is oracle a language?

987

How to generate query output in html format?

1206

What is Trigger in Oracle?

1238