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
Is it possible to query a hash file?
What is the difference between odbc and drs stage?
What is a merge?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the purpose of interprocessor stage in server jobs?
How to clean the datastage repository?
What are system variables and sequencers in datastage
What are the different plug-ins stages used in your projects?
What is process model?
What is a merge in datastage?
How do u convert the columns to rows in datastage?
how many rows sorted in sort stage by default in server jobs
What is ds designer?
What are the types of containers?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?