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 / 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
Can you highlight the main features of ibm infosphere information server?
What are some different alternative commands associated with "dsjob"?
Explain connectivity between datastage with datasources?
What is process model?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How do you import and export data into datastage?
How do you generate sequence number in datastage?
Define APT_CONFIG in Datastage?
What is job control?
How rejected rows are managed in datastage?
What are the processing stages?
What are the types of containers and how to create them?
what is the use of skid in reporting?
Name the third party tools that can be used in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?