Forum: MySQL  Nov 18th, 2006 |
| Replies: 1 Views: 2,008 This belongs in the MSSQL forum, but the corresponding datatype is the more powerful identity data type. I don't think it supports 'random' like access, but you can start from any number, and you can... |
| Forum: MySQL Oct 22nd, 2006 |
| Replies: 2 Views: 14,612 try:
SELECT username, SUM(daily_units+rare_units) FROM table GROUP BY username ORDER BY SUM(daily_units+rare_units) desc
the sum function works by summing rows, not separate fields (i.e. it... |
