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

What is the query to find nth highest salary?
What is the use of cursors?

Answer Posted / sree

select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);

Is This Answer Correct ?    5 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is $$$$?

2204


Explain constraint based loading in informatica

1157


What is olap (on-line analytical processing?

1112


explain one complex mapping with logic? sales project?

6738


Target increases every day even though no new record was inserted

1627


How to load the data from a flat file into the target where the source flat file name changes daily?

1106


Does an informatica transformation support only aggregate expressions?

1088


Implementation methodology

1776


What is mapplet in informatica?

1129


What are the different transaction levels available in transaction control transformation?

1278


How can we create index after completion of load process?

1168


What is the difference between informatics 7x and 8x and what is latest version?

1141


how to load dimension table and fact table. plz tell me the steps.

2145


Explain target update override in informatica

1190


Enlist few areas or real-time situations where informatica is required.

1144