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
6435 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

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers TCS,

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers IBM, PR3 Systems,

What are stage variables, derivations and constants?

0 Answers

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers IBM, ME,

How can we improve performance of data stage jobs?

0 Answers

Which type of joins Merge stage can support?

7 Answers IBM,

what is main difference between change capture and change apply stages

4 Answers IBM,

How can you join flat file, oracle as a sources?

4 Answers IBM,

What is exact difference between Parallel Jobs and server Jobs..

7 Answers IBM,

What is oci?

0 Answers

what are the types of nodes

4 Answers HCL, TCS,

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers HCL,

For more Data Stage Interview Questions Click Here