在聚合功能方面需要一些帮助 [英] need some help in aggregation function

问题描述

CAST（（

SELECT td = dueTask.ASSIGNED_TO_TEAM_NAME，''''，

td = dueTask.ASSIGNED_TO，''''，

td = COUNT（*） //如何按升序排序

FROM [dbo]。[tasks] as dueTask

where（TASK_STATUS =''Open'';）GROUP BY ASSIGNED_TO_TEAM_NAME，ASSIGNED_TO

FOR XML PATH（''tr''），TYPE

）AS NVARCHAR（MAX ））+





td是html标签（

） i我试图在任务表中对count（*）cloumn进行排序。 请帮帮我

解决方案

从未尝试过你的语法;将SQL直接绑定到HTML标签..

但您可以尝试使用COUNT（*）nCount命名COUNT（*）
然后添加ORDER BY nCount

，让我知道它是怎么回事..

虽然排序工作了吗？



用于放置值

标签，它应该仍然存在，因为你只会从td = COUNT（*）更改为td = COUNT（*）nCount

CAST ((
SELECT td=dueTask.ASSIGNED_TO_TEAM_NAME,'''',
td=dueTask.ASSIGNED_TO,'''',
td=COUNT(*)//how to sort it by ascending order
FROM [dbo].[tasks] as dueTask
where (TASK_STATUS = ''Open''; ) GROUP BY ASSIGNED_TO_TEAM_NAME, ASSIGNED_TO
FOR XML PATH(''tr''), TYPE
) AS NVARCHAR(MAX)) +


td is the html tag(

) i am trying to sort the count(*) cloumn in task table . please help me

解决方案

never tried your syntax; tying SQL directly to HTML tags..
but can you try naming COUNT(*) by using COUNT(*) nCount
then add ORDER BY nCount
and let me know how it goes..

did the sorting work though?

for placing the value in

tag, it should still be there since you will only be changing from td=COUNT(*) to td=COUNT(*) nCount

这篇关于在聚合功能方面需要一些帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！