|
|
Posted by Jason Lepack on 07/26/07 19:21
select
sum(box)
from (
select top 2
box
from
your_table
order by
id desc)
Cheers,
Jason Lepack
On Jul 26, 3:16 pm, mcolson <mcolson1...@gmail.com> wrote:
> I am trying to create a stored procedure that will add the last two
> entries from a column. If I had a column named box, I would want to
> add the two values in box, for which my ID column is Max and Max-1.
>
> Is there anyone who can help me with this?
>
> Matt
Navigation:
[Reply to this message]
|