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

select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we change Dynamic to Static or Persistent cache? If so what happens?

2189


How many types of sessions are there in informatica.please explain them?

1141


What is workflow? What are the components of the workflow manager?

1101


Performance tuning in UNIX for informatica mappings?

2545


Write the different tools in the workflow manager?

1046


What is the meaning of up gradation of repository?

1954


How can you increase the performance in joiner transformation?

1181


What you know about transaction control transformation?

979


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3848


What is the Rank index port in Rank transformation?

1043


What is the maplet?

1089


What is substr in informatica?

1176


Differences between connected and unconnected lookup?

1201


Can we create two repositories on same database instance in oracle?

1072


What is the difference between informatica 7.0 and 8.0?

988