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 are the types of lookup transformation?

1059


Write the program through which the records can be updated?

984


According to his methodology what all you need before you build a datawarehouse

1741


How union transformation is used?

991


What are active transformations.

1640


Mention few advantages of router transformation over filter transformation.

1019


Why do you use Mapping Parameter and mapping variable?

1743


Explain dynamic target flat file name generation in informatica

1036


Can we create a Integration service without a Repository service and vice versa?

1204


What are the advantages of informatica?

997


Plz can any one say me how to get the informatica certification materials and dumps

2034


EXL informatica Questions

1360


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7358


What is a sequence generator transformation?

1000


COM components can be used in Informatica

2368