SQL中的数据库查询 [英] Database Query in 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

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