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
How many types of sorting methods are available in datastage?
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
project Steps,hits, Project level HArd things,Solved methods?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is a merge?
What is a quality stage in datastage tool?
What is job control?
What is merge stage?
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)
root tree will find which is server job and which is parallel job?
How to RD using transformer?
What is the use of hoursfromtime() function in transformer stage in datastage?
Where do the datastage jobs get stored?
Why we use surrogate key?
Define meta stage?