? Sort by a summation of columns ?
| From: | Noah Spitzer-Williams | Date: | Sat, 25 Nov 2000 11:43:25 +0000 |
| Subject: | ? Sort by a summation of columns ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4733@lists.php.net to get a copy of this message | ||
I have a database setup as follows:
some fields... | v1 | v2 | v3 | v4 | v5
some fields... | v1 | v2 | v3 | v4 | v5
some fields... | v1 | v2 | v3 | v4 | v5
how can i retrieve a list of these rows sorted by the sum of v1 + v2 + v3 +
v4 + v5?
for instance, can i do like : ORDER BY sum(v1,v2,v3,v4,v5)?
- Noah
-- Thanks!
-----------------
The DevBoard - http://www.thedevboard.com
-----------------
http://www.alladvantage.com/go.asp?refid=BIY971
- AllAdvantage