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
BID Time 7 30
SELECT Bid as BID, sum(Time) FROM myTable GROUP BY Bid
Select Bid,sum(Time) from table group by Bid
SELECT Bid, sum(Time) Time FROM YourTable GROUP BY Bid
select bid,sum(time) from table group by bid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)