how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql.
output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

ename like ibm,tcs,hcl need display those records only how?

2 Answers  


30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  


I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,


Can you explain engine tier in information server?

0 Answers  


sed,awk,head

0 Answers   CTS,






i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,


I am getting input value like X = Iconv(ā€œ31 DEC 1967ā€,ā€Dā€)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,


Main Function of the Staging area in DWH ?

2 Answers  


what is the main difference between sorragate key n primary key in one word

2 Answers  


i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc Ple help any one?

4 Answers   SLK Software,


Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  


What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,


Categories