I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...2 1924
What are routes in apache camel?
What is the different type of users in sap?
Can you explain the difference between architecture followed in 10g & 11g?
How many types bend used in civil reinforcing
Why you want to change the job line (i.e. Secretary to Back-ed-process
What is google payday loan (spam) algorithms?
what is mean by c32/40s concrete class
What is hadoop role in an enterprise data hub?
How does ethylene oxide sterilize?
Explain fram control?
What is the difference between xhtml, html 4 and html 5? Which one do you use typically?
State and prove necessary condition for extreme values of the function f (x,y)
How to dump a table to a file with 'mysqldump'?
How do you test the script?
when u script reveiwing in which area u more concentrates?