Please help

[bassplayer]

I have 2 questions:
1) How do you add together all the numbers in a column?
2) How do you get just the most recent addition to a column e.g. the last number in the id field.
Thanks for your help.

[cgraz]

1.

SELECT SUM(column_name) AS total FROM table;

2.

SELECT * FROM table ORDER BY id DESC;

Cgraz

[Pig]

or, for #2 if you don't want the whole table

SELECT MAX(col_name) as my_var FROM table_name