I have a table as follows:
Columns = id, date
Id - Date1 - 12-09-20112 - 12-28-2011
I need to do a select statement that will pull the amount of days between the two rows.
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