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

select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Dataware house architecture .how data flow from intial to end?

2575


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2031


What are connected or unconnected transformations?

1102


What is persistent lookup cache?

1017


Briefly describe lookup transformation?

1033


Can you use flat files in Mapplets.

2646


What is joiner transformation?

987


Enlist the differences between database and data warehouse.

1103


What is the difference between writing a joiner query in ANSI style and THETA style?

2372


What is the difference between router and filter?

1243


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1095


How many number of sessions can one group in batches?

1147


What is the use of target designer?

1026


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2323


Differentiate between joiner and lookup transformation?

1095