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 2102
What is the main purpose of excel?
No of ways of doing deployments?
how do you go about setting goals with subordinates?
What is routerstate in routers?
When workflow even fires?
How many types of streams are available in node.js?
How many scripts did you have?
what are the types of dimensioning?
What is an example of taxonomy?
Explain something about attribute?
What is the name of the java compiler?
What is the Surge suppresor? Why using in a UDB's and How it works?
Is uikit thread safe?
What type of pump is are commonly used in auxiliary boilers?
How many bytes is a url?