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

Answer Posted / sikindar

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a proxy class?

1054

What is format trigger?

2074

How to convert characters to numbers in oracle?

1065

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3200

What is merge in oracle?

1054

Give the various rollback segment states.

1052

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1842

what happened to the global index when I truncate the data in one of the partition?

2022

How to display row numbers with the records?

1080

What is object data modeling?

968

What do you mean by a tablespace?

1039

What is oracle open database communication (odbc)?

1028

Design database draw er diagram for a certain scenario ?

4579

Is the After report trigger fired if the report execution fails ?

2915

How to do clean up if create database failed?

1028