I have a table which has 1 ref no and 3 diff status column like status1,status2 and status 3 and for each status I want a separate row. Addition to that in output we shall have a sequence no column for each status if statuses are started, pended and closed then sequence no will be 1,2 and 3. Multiple rows will be created for each status.
I was not able to do this solution.
New contributor
SuperAmitbond is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.