如何在GridView中显示价格总计

问题描述：

我是SQL编程的新手.需要您的建议.
这是我的要求:

以下是我的示例数据

创建表测试(TransactionDate DateTime，价格INT，无INT)
我在表格Test
中插入一些如下所示的值 ------------------------------------
TransactionDate价格编号
------------------------------------
2007-01-21 16:01:00.000 61 23
2007-01-12 07:03:00.000 94 31
2007-01-24 00:13:00.000 71 26
2007-02-08 02:43:00.000 89 27
2007-02-09 20:41:00.000 53 21
2007-02-09 18:43:00.000 58 32
2007-02-22 11:00:00.000 81 19
2007-02-14 07:39:00.000 50 25
2007-03-15 00:17:00.000 45 23
2007-03-03 22:07:00.000 41 18
2007-03-15 09:17:00.000 85 30
2007-03-07 15:51:00.000 34 13
2007-03-07 21:05:00.000 53 18

出于上述原因，我希望得到如下select语句的结果

成绩取决于某些范围和
-----------------------------------------
GroupwiseMonth Groupwise总成绩
-----------------------------------------
1月63日A
2月55日c
3月61日B
-----------------------------------------
合计:179
-----------------------------------------

我想在GridView中这样显示，所以请帮助我，先生.....

并向我发送一些最佳的DateTime函数链接以进行练习....

I am new to Programming in SQL. Need your suggestions.
Here is my requirement:

Below is my sample data

CREATE TABLE Test(TransactionDate DateTime, price INT, no INT)
I insert some values like below into the table Test
------------------------------------
TransactionDate Price no
------------------------------------
2007-01-21 16:01:00.000 61 23
2007-01-12 07:03:00.000 94 31
2007-01-24 00:13:00.000 71 26
2007-02-08 02:43:00.000 89 27
2007-02-09 20:41:00.000 53 21
2007-02-09 18:43:00.000 58 32
2007-02-22 11:00:00.000 81 19
2007-02-14 07:39:00.000 50 25
2007-03-15 00:17:00.000 45 23
2007-03-03 22:07:00.000 41 18
2007-03-15 09:17:00.000 85 30
2007-03-07 15:51:00.000 34 13
2007-03-07 21:05:00.000 53 18

Out of the above I would want to have the result of a select statement as below

grade depends on some ranges and
-----------------------------------------
GroupwiseMonth GroupwiseTotal Grade
-----------------------------------------
Jan 63 A
Feb 55 c
Mar 61 B
-----------------------------------------
Total : 179
-----------------------------------------

I want to display like this in GridView so please help me sir.....

and send me some of best DateTime functions links for practice....

答

要按月分组，您可以使用 ^ ].例如:

To group by the month yu can use DATEPART[^]. For example:

SELECT DATEPART(month, TransactionDate), SUM(price)...
FROM Test
GROUP BY  DATEPART(month, TransactionDate)

根据年级的逻辑，您可能必须更改查询的结构.

Depending on the logic of the grade you may have to change the structure of the query.

请尝试以下查询:

我在sql中没有任何表，请检查一下.如果无法解决，请在我这边尝试.

try below query:

I don''t have any table in sql, pls check it. if not solve then try at my side.

Select CONVERT(CHAR(4), TransactionDate, 100), SUM(Price) from Test group by CONVERT(CHAR(4), TransactionDate, 100)

如何在GridView中显示价格总计

相关推荐