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

How to retrieve 5th highest sal from emp table?

Answer Posted / aryasen vaikom

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

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we protect our pl/sql source code?

1084


Explain self joins in oracle?

1063


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2064


Explain the use of file option in exp command.

1177


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2147


Explain the blob datatype?

1125


Compare and contrast between sql and sql server and explain its various functions?

1019


Explain the dml?

1051


What is the maximum number of triggers that can be applied to a single table?

1069


How to drop a stored procedure in oracle?

1106


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1975


What are the different types of synonyms?

1200


What is a table in oracle?

1024


What is a sub query? Describe its types?

1074


How to loop through a cursor variable?

1128