行到列在Sql中 [英] Row to Column in Sql

问题描述

我有这张桌子.

Hi I am having this table.

Name       RollNo       Date         Forenoon      Afternoon

Ravi        101       01/07/2012     Present        Present

Ravi        101       01/08/2012     Present        Absent

Ravi        101       01/09/2012     Present        Present

我需要这个输出

I need This output

Name      RollNo          01/07/2012           01/08/2012              01/09/2012 

                       Forenoon Afternoon    Forenoon Afternoon    Forenoon Afternoon

Ravi       101         Present   Present      Present   Absent      Present   Present

推荐答案

您是否尝试过在SQL语句中使用PIVOT子句?

此链接 http://sqlserver2000.databases. aspfaq.com/how-do-i-create-a-cross-tab-or-pivot-query.html [

Have you tried to use the PIVOT clause in the SQL statement?

This link http://sqlserver2000.databases.aspfaq.com/how-do-i-create-a-cross-tab-or-pivot-query.html[^] provides a bit more info...

HTH

尝试以下 PIVOT [ ^ ]

这篇关于行到列在Sql中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！