Select statement

I have a table as follows:

Columns = id, date


Id - Date
1 - 12-09-2011
2 - 12-28-2011

I need to do a select statement that will pull the amount of days between the two rows.

Any ideas?

lots of ideas here

do you mean those two rows specifically? the rows with id=1 and id=2?

the actual date calculation is trivial

matching up the two rows you want is going to be a wee bit trickier