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
ename like ibm,tcs,hcl need display those records only how?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
Can you explain engine tier in information server?
sed,awk,head
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
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().
Main Function of the Staging area in DWH ?
what is the main difference between sorragate key n primary key in one word
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?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the version control how can i apply this in DataStage can any one tell me the anser