I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL--

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4
ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000
DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH
HIGEST SAL ?

Question Posted / simha

2 Answers
6321 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000..

Answer / subhash

Select MAX(SAL) FROM EMP
where to_char(Date,'MM-YYYY')=to_char(sysdate-1,'MM-YYYY')

Is This Answer Correct ?

1 Yes

1 No

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000..

Answer / indu

select max(sal) from emp where to_char(Date,'MM-YYYY')
=to_char(dateadd(month, -1, GETDATE()),'MM-YYYY');

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers HCL,

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers IBM, Polaris,

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers IBM,

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers Cap Gemini, IBM,

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers Syntel, TCS,

What are routines in datastage? Enlist various types of routines.

0 Answers

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers IBM, TCS,

Is the value of staging variable stored temporarily or permanently?

0 Answers

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers

What are the types of jobs we have in datastage?

0 Answers

data stores in which location while using data set stage as the target?

1 Answers IBM, TCS,

For more Data Stage Interview Questions Click Here