How to solve this problem?
Good day everyone
I'm a begginer at Databasises filed
I have a major exam on next week. I was studying SQL and I found this "Simple" problem in the book... Here is the orignal Table
http://www.upfiles.com/upfiles/upload/212-1128766377.jpg
and I want the output to be like this
http://www.upfiles.com/upfiles/upload/212-1128766614.jpg
Thank you for taking the trouble to read my post
[431 byte] By [
LuisFigo] at [2007-11-11 7:00:17]

# 2 Re: How to solve this problem?
Doesn't the book explain how to do it?
IT'S FROM THE QUESTIONS AT THE END OF EACH CHAPTER
# 3 Re: How to solve this problem?
There is a website where I learned SQL and creative formatting like that in your quesion. That site is: http://www.sqlcourse.com/
(I have no affiliation with that site and this is not spam!)
The poster can learn formatting there that will answer his question.
Good luck.