在sql server 2008中的单个表中按功能分组 [英] group by functionality in single table in sql server 2008

问题描述

在sql server 2008的单个表中按功能分组。



提前致谢。

group by functionality in single table in sql server 2008.

Thanks in advance.

推荐答案

尝试此查询 -



SELECT< column1>，< column2>，< column3> FROM< table_name>

GROUP BY< column1>，< column2>，< column3>

try this query -

SELECT <column1>,<column2>,<column3>FROM <table_name>
GROUP BY <column1>,<column2>,<column3>

SELECT column1,column2,SUM(column3)
FROM Table_Name
GROUP BY column1,column2

SELECT column1,column2,SUM(column3)
FROM Table_Name
WHERE column1='' AND column4=''
GROUP BY column1,column2

等等



问候

Rakshit

and so on

Regards
Rakshit

你可以参考



http://www.sqlteam.com/article/how-to-use-group-by-in-sql-server [ ^ ]

这篇关于在sql server 2008中的单个表中按功能分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！