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

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1422

Name the command line functions to import and export the DS jobs?

1161

On which interface you will be working as a developer?

1055

What are the differences between datastage and informatica?

1183

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2500

What is datastage engine?

1186

How do y read Sequential file from job control?

15975

Which algorithm you used for your hashfile?

1188

what are the errors,warnings in datastage

2706

how to delete one row in target dataset

3127

What are the main differences you have observed between 7.x and 8.x version of datastage?

1091

Define project in datastage?

1103

Why do you need stage variables?

1187

What is the purpose of interprocessor stage in server jobs?

2233

What are sequencers?

1124