I am using MySql DB. My table looks as below:
And I would like to get the output as follows:
I tried to use Over Partition and other method, however I couldn't get what I want. Can someone kindly help?
Asked
Active
Viewed 25 times
0
-
Voted to close because your question shows zero research or effort. If you try something in the duplicate link and get stuck, then come back here, include your query, and someone can reopen this question. – Tim Biegeleisen Jan 24 '18 at 10:31
-
I tried to click 6 to 7 links after stackoverflow suggested. But can't get result. Also did 2 hours research google. But still cant find solution. – Senthil Jan 24 '18 at 10:35
-
Well now you have the duplicate link. – Tim Biegeleisen Jan 24 '18 at 10:35
-
Agree Tim. I saw earlier and thought the solution didn't fit mine. After reading again and again. I could achieve what I want. Thanks. – Senthil Jan 25 '18 at 08:17