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

select distinct(e1.sal) from emp e1 where &n=(select count(distinct(e2.sal)) from emp e2 where e1.sal <=e2.sal)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2070


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1120


What is a filter transformation?

1092


How do you manage the Parameter files while migrating your data from one environment to another environment?

1069


What is an unconnected transformation?

1129


Describe data concatenation?

1125


Define Pmrep command?

1113


What is data transformation manager process?

1221


what are factless facts? And in which scenario will you use such kinds of fact tables.

1856


What is the difference between STOP and ABORT options in Workflow Monitor?

1311


Which transformation should we use to normalise the COBOL and relational sources?

1268


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1799


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

7499


what is song in infrmatica...?

2320


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193