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 4584Post New Amex Informatica Interview Questions
What is meant by jms?
How do I find my ip address?
What does Nominal size in a valve means like NG6,NG10 etc
How do Acoelomates maintain homeostasis and regulate internal body conditions without a body cavity?
Why do you prefer selenium automation tool?
What is huffman’s algorithm?
Is struts efficient?
What are factors for performance tuning in data services?
Hi , We have urgent opening for Test Analyst to our UK client. So testing Professionals Please visit www.sohumsolutions.com & in career setion you can get all requirement specification If you are interested onsite oppertunity Please email me your CV & along with your current salry details & expectation,Visa Status. If you don't have any Visa want to take UK Visa then we can cooperate you ! Thanks & Regards, Prabha Koshti Director Sohum STAFFING Solutions contact+91-(020)27610012 Mobile:+91-(0)-9822914878 Email :prabha.koshti@sohumsolutions.com
List Some Skills Needed To Handle A Difficult Employee?
What is a fragment?
What is the advantage of using minimized version of jQuery?
What is 0xc0000142 error?
How to calculate quality score?
Explain sap system transactions?