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

What are the functionalities of link partitioner?

1003

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

919

What are stage variables, derivations and constants?

1203

What are iconv and oconv?

1221

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1482

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2231

What is apt_config in datastage?

1122

whom do you report?

1913

What are the steps needed to create a simple basic datastage job?

1213

What are the various kinds of the hash file?

1134

Define Merge?

1296

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3453

what is use of SDR function?

5156

Where the datastage stored his repository?

1073

Define Data Stage?

1074