修改SQL查询 [英] modify sql query

问题描述

DataTable

ATTID int
BID int
Bcode varchar
名称varchar
日期datetime
Ptype varchar


我只想显示Bcode名称日期& foll查询中的Ptype
请帮助我

-------------------------------------------------- --------

DataTable

ATTID int
BID int
Bcode varchar
Name varchar
Date datetime
Ptype varchar


I want to display only Bcode Name Date & Ptype in foll query
plz help me

----------------------------------------------------------

DECLARE @columns VARCHAR(8000)

SELECT @columns = COALESCE(@columns + ',[' + cast(date as varchar(11)) + 

']',
'[' + cast(date as varchar(11))+ ']')
FROM tbl_K_Attendance
GROUP BY date


DECLARE @query VARCHAR(8000)

SET @query = '
select * from tbl_K_Attendance
PIVOT
(
MAX(Ptype)
FOR [date]
IN (' + @columns + ')
)
AS p'

EXECUTE(@query)

[修改:添加了前置标记]

[Modified: added pre tags]

推荐答案

如果您只想查看以下列:

从tbl_K_Attendance中选择Bcode，名称，日期，Ptype

这是SQL中的简单SELECT语句.我建议您看一些在线教程或购买一本SQL书籍.

If all you want to do is see those columns:

SELECT Bcode, Name, Date, Ptype FROM tbl_K_Attendance

This is a simple SELECT statement in SQL. I recommend looking at some online tutorials or purchasing a SQL book.

这篇关于修改SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！