Difference between first reading and second reading? [message #375831] |
Mon, 15 December 2008 01:41  |
arunsuresh100
Messages: 38 Registered: December 2006
|
Member |
|
|
Hi,
Meteorological department recorded the temperature on daily basis. The table data would be like this
Date Celsius(Temperature)
2008-12-07 40
2008-12-08 45
2008-12-09 35
2008-12-10 37
2008-12-11 50
We need to find the difference of temperature between today & yesterday. The sample result given below:
Date Temperature Difference
2008-12-08 5
2008-12-09 -10
2008-12-10 2
2008-12-11 13
Please provide solution using SQL queries.
|
|
|
|
|