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

What is blocking transformation?

1152


What is complex mapping?

1127


Whats the difference between informatica powercenter server, repositoryserver and repository?

1179


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4167


what is song in infrmatica...?

2240


Explain transaction control transformation in informatica

1275


How can you generate reports in informatica?

1037


What is union transformation in informatica?

1151


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2187


What is informatica worklet?

1072


What is informatica etl tool?

1003


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

3872


What do think which one is the better joiner or look up?

1205


Explain the shared cache and re-cache?

1124


How would you join a node to the already existing domain?

1131