select max(sal) from emp where to_char(Date,'MM-YYYY') =to

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 / indu

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

889

Can you define merge?

1068

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5046

What are the components of ascential data stage?

1115

Describe the main features of datastage?

1039

What is the difference between Datastage 7.5 and 7.0?

1051

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3736

What are system variables and sequencers in datastage

1073

What are the primary usages of datastage tool?

1018

How the ipc stage work?

1081

How do you import and export data into datastage?

1169

What are the different layers in the information server architecture?

1080

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3268

what is repositery?

1771

What are the different common services in datastage?

1216