Adding values in DB

[NZ_Kiwis]

I have a DB with two colums team1score and team2score...

I want to select the row which has the highest combined two scores... how can i do this?

[dagon]

SELECT *, team1score+team2score as total FROM DATABASE order by total DESC Limit 1

[bradgrafelman]

Couple of things to note about the above example query:

1. 'SELECT *' should never be used - name ONLY the the columns that you're going to use.

2. dagon probably meant 'TABLE' where he put 'DATABASE'.

[dagon]

1. I didn't know what, if any, other field(s) were wanted, but absolutely never use *

2. Yup

3. Thanks. 😃