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

What is ibm datastage?

955

Explain ibm infosphere information server and highlight its main features?

1081

What is oci?

1286

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

1136

What is active and passive stage?

1404

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1727

Describe the main features of datastage?

1066

What all the types of jobs you developed?

1167

how to add a new records into source?

1981

What are the differences between datastage and informatica?

1163

Describe the architecture of datastage?

996

Can you explain link buffering?

1159

What is a ds designer?

1058

What is the difference between operational data stage (ods) and data warehouse?

1224

How complex jobs are implemented in datstage to improve performance?

1021