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 1876
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: firstname.lastname@example.org
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?