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 ?
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
How many types of sorting methods are available in datastage?
What are the main features of datastage?
What are the differences between datastage and informatica?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the different layers in the information server architecture?
Why do we use link partitioner and link collector in datastage?
root tree will find which is server job and which is parallel job?
How do you import and export the datastage jobs?
How many areas for files does datastage have?
Terminate Activity
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Lookup constraints
Why fact table is in normal form?
what are the errors,warnings in datastage
How to RD using transformer?