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 4452Post New Amex Informatica Interview Questions
Can anybody tell when sbh dispatches appointment letters for Clerical for people completed medical and scrutiny of documents on 15/08/09?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
have you ever implemented new tsm server? What is the process?
Explain commit, rollback and savepoint.
What is the use of the bootstrap directory?
What is named calculation? : sql server analysis services, ssas
Should you run disk cleanup or defragment first?
Hi every body i am going to take the ISTQB Foundation level Exam on March 21th 2010, Could any one send some list of question papers and latest Dumps to My mail id: (saran_loyola05@yahoo.co.in). Advance thanks. Regards, Saran
What is the difference between pages and posts on wordpress?
Mention the difference between breadth first search and best first search in artificial intelligence?
Which are the important pulsating nebulae?
Name the different types of memory?
Differentiate between statement lambda and expression lambda.
The simple way of finding the leakage quantity and % in compressed air distribution system
What are the differences between the response.write() and response.output.write()?