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

Explain the importance of surrogate key in data warehousing?

1237

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3695

Which algorithm you used for your hashfile?

1234

how to delete one row in target dataset

3166

How a routine is called in datastage job?

1165

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

2501

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

1203

What are stage variables, derivations and constants?

1285

Can you explain link buffering?

1225

To see hidden files in LINIX?

1593

What are the steps required to kill the job in Datastage?

1271

Can you explain kafka connector?

1380

What is a quality stage in datastage tool?

1132

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

5197

How rejected rows are managed in datastage?

1578