I have a table as follows:
Columns = id, date
Data:
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?
I have a table as follows:
Columns = id, date
Data:
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?
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