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...

how to retrive the max(sal),deptno,empno in datastage?

Answer Posted / srinu

select sal,deptno,empno from emp where sal=(select max(sal)
from emp);
this is write answer check that......after checking any
queries ask me..........

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of sorting methods are available in datastage?

1114


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2266


project Steps,hits, Project level HArd things,Solved methods?

2182


how do u catch bad rows from OCI stage? And what CLI stands for?

2852


What is a merge?

1238


What is a quality stage in datastage tool?

1127


What is job control?

1194


What is merge stage?

1381


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2444


root tree will find which is server job and which is parallel job?

2037


How to RD using transformer?

1472


What is the use of hoursfromtime() function in transformer stage in datastage?

1111


Where do the datastage jobs get stored?

1268


Why we use surrogate key?

1304


Define meta stage?

1258