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 1646Post New Amex Informatica Interview Questions
am from coimbatore.am learning php&mysql. what will be the approx salary for me if i get a job in coimbatore.
what is the proper location of sample point for sphere tank?
How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet
Sir pl provide 5 year sample paper for post junior engineer(electrical).I have currently applied for junior engineer (electrical) on RRB Ajmer
What is DDR (Double Data Rate)
i have done M.S. in organic chemistry and now i got admission in M.B.A. (human resource management) but i dont know how i corelate my degree with M.B.A. to convence visa officer
If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.
why script is client dependant.
hai everybody... wish u all the best for those who got selected in sbi associate bank is anyone from coimbatore region attending on 27th may 2009.
What is Mixed Testing
WHAT ARE THE PREPRODUCTION ACTIVITIES? HOW CAN YOU SETUP THE OPENING BALANCES?
how do we calculate physical address if logical address is given in the question?
Why phase sequence must be same in any ht motor or generator circuit?if phase sequence doesn't same whatever will be affect on circuit?
What is Serial Poart ?
How to Change the font style of a dbgrid row ?
