gopi6417 (2/25/2015)
I don't know exactly.Could you please tell the syntax on Oracle.
The poster realised after posting the original question that they were in the wrong forum.
So if you are providing a SQL Server solution, it is unlikely to help the poster. Might help other people in the future, of course.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin