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 1876Post New Amex Informatica Interview Questions
-
Amex Informatica Interview Questions (1)
- Amex SAS Interview Questions (1)
- Amex HR Questions Interview Questions (1)
- Amex SAP SD Interview Questions (1)
- Amex Electrical Engineering Interview Questions (1)
- Amex Banking Finance Interview Questions (1)
- Amex Audit Interview Questions (1)
- Amex Accounting General Interview Questions (1)
- Amex Call Centre AllOther Interview Questions (4)
- Amex English Interview Questions (1)
- Amex H1B Visa Interview Questions (1)
how to calculate the formula of cable size if motor kw is given
How to decide CT & PT ratings for a given transmission line carrying some rated voltage?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
what is the difference between sd account key and fi account key?what si a variant and its use?
What is a magnetic valve of refrigeration system?
What is fast enumeration in iOS operating system?
Anyone have sample questions for bhel interview.please send me as Iam appearing for the interview on 19th sep2008. Kindly send this to my e-mail: arun_prasath_n@yahoo.co.in
What is declarative security ?
what is the list of building construction equipment & teir output?
Differentiate between % rowtype and type record.
How to find a window is minimized or not
Why does a company issue stock?
Can anyone tell me where i can Download free full version of test director
What happens if an exception is throws from an object's constructor?
what energized you to complete your course?
