How do you add values on a table column?

[Davidc316]

Let's say we've got a database which contains information about football teams. There is one column called "no_of_players". Each row for that column tells you the number of players in each football team.

Is there an SQL command that I could use to add up the grand total number of players in the league????

Thanks!

[steadyguy]

Yes:

SELECT SUM(no_of_players) FROM table_name;