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

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

2244

How will you move hashed file from one location to another location?

2154

explain about citrix scheduling tool in datastage

2458

What are the different common services in datastage?

1288

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

Which warehouse using in your datawarehouse

2188

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

3460

How we can covert server job to a parallel job?

1151

What are some different alternative commands associated with "dsjob"?

1169

How do you import and export the datastage jobs?

1161

What are datastage sequences?

1124

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2453

Define APT_CONFIG in Datastage?

1084

what are the errors,warnings in datastage

2703

What is ds designer?

1108