Shulou(Shulou.com)06/01 Report--

Editor to share with you how sql to achieve row-to-column conversion, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Row-column conversion

Question: suppose there is a student report form (tb) as follows:

Want to become (get the following results):

Code:

WITH tb (name, course, score) AS (SELECT N 'Zhang San', N 'Chinese', 74UNION ALLSELECT N 'Zhang San', N 'Mathematics', 83UNION ALLSELECT N 'Zhang San', N 'Physics', 93UNION ALLSELECT N'Li Si', N 'Chinese', 79UNION ALLSELECT N'Li Si', N 'Mathematics', 86UNION ALLSELECT N'Li Si', N 'Physics', 88) SELECT name, MAX (CASE course WHEN 'Chinese' THEN score ELSE 0 END) MAX (CASE course WHEN 'Mathematics' THEN score ELSE 0 END) Mathematics, MAX (CASE course WHEN 'Physics' THEN score ELSE 0 END) Physics FROM tb GROUP BY name above is all the content of the article "how to achieve row-to-column conversion in sql" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.