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

Name the third party tools that can be used in datastage?

1024

On which Dimension Table you implemented SCD Type in your Project

1972

How a routine is called in datastage job?

1045

Explain how a source file is populated?

1316

Differentiate between datastage and datastage tx?

1008

What is the purpose of pivot stage and types of containers in datastage

996

Can you implement SCD2 using join, transformer and funnel stage?

1502

Lookup constraints

1204

To see hidden files in LINIX?

1455

What is a quality stage in datastage tool?

1025

How many types of hash files are there?

1123

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

2201

What is the use of hoursfromtime() function in transformer stage in datastage?

1003

What are the components of ascential data stage?

1115

What are the important features of datastage?

1052