Wilfried Mestdagh wrote: > > Hi Guillaume and Martin, > > Thanks for quick responce. Studying the count() function if I use the > method of Guillaume I dont need the 'where' clause: > > 'select count(VehicleID) from tx' > > But I assume all 3 methods will do internal exact the same. Result is > also 1 field with the count in it. >
No, they will probably not all do the same internally: the result may be the same, but the "virtual machine" that runs the SQL statements will very probably do different things - this depends on optimisation and so on. But for most of us it is mainly the result that counts (and the time it takes for that result) Regards, Arjen
