SELECT *,sum(Duration) as durationsum from table1 WHERE condition should work,
Thomas On Wed, 18 Sep 2002 10:32:07 +0300 "adi" <[EMAIL PROTECTED]> wrote: > > Hi, I have a table table1, with a column "Duration" time type(ex 00:12:30) > I want to make a sql selection: > SELECT * from table1 WHERE condition, and after that, to make sum of values > of column "Duration" and display it. > Any Help? > tx > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php