SQL中的数据库查询

问题描述：

大家好，

我有一个像下面的表格结构

Hi All,

I have a table structure like below

Date	      PID	Time	Bid	Task	Uid	Cflag	Hflag
10/10/2012	12	10	7	Break	10	1	0
10/10/2012	NULL	10	7	Meeting	10	2	1
10/10/2012	NULL	10	7	Break	10	2	1

我需要每次竞标的时间总和

结果:

i need the sum of time for each Bid

Result :

BID    Time

7       30

请帮助我编写sql查询

在此先感谢
莫汉

[edit]已添加代码块-OriginalGriff [/edit]

please help me to write sql query

Thanks in advance
Mohan

[edit]Code block added - OriginalGriff[/edit]

答

尝试:

SELECT Bid as BID, sum(Time) FROM myTable GROUP BY Bid

Hi,

Select Bid,sum(Time) from table group by Bid

试试这个查询

Hi,
Try this query

SELECT Bid, sum(Time) Time FROM YourTable GROUP BY Bid

谢谢

Thank you