Select Count

[MitchEvans]

Is it possible to do a select query using count, I already use:

SELECT sum(total) as 'sumtotal'

And was wondering if I could use:

SELECT count(total) as 'counttotal'

[laserlight]

Try and find out 😉

[dream_scape]

Yes that is possible. It will count the number of rows that match the WHERE clause (or in absence of the clause it will count all rows)