Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

grand total in mysql

Comment:

how can i get grand total of some rows without group by clause, It is something like getting a grand total in every select command.

Name: StuartS
Date: April 2, 2006 at 08:19:47 Pacific

Reply:

SELECT sum(FieldName)as [variable] FROM Tablename The result will be returned in variable. You can be more selective by adding a WHERE clause. Stuart

0

Name: Michael J (by mjdamato)
Date: April 2, 2006 at 22:00:43 Pacific

Reply:

And, it is the grand total for a column, not a row. A row is a single record in a table, whereas a colum is a certain property of all records. Michael J

0

error msg in Aglets

Populating 2d array in C+...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: If you have Set var_1=100 Set var_2=200 Set var_3=300 then SetLocal EnableDelayedExpansion Set Tot=0 For /L %%j in (1,1,%x%) Do ( Set /A Tot+=!var_%%j!) Echo Tot=%Tot% performs the grand total of %x% ...

Summary: Hey, I was wondering if anyone could answer a query for me, I am doing a Project in PHP and am writing the scripts for my database in MySQL and was wondering, Does every Table in the Database have to...

Summary: Hello everyone. i have a problem that i believe should be quite easy to solve but for some reason i cannot make it work. I have a number of strings within a list1box i presume you can only store value...