Dear All, My Mysql Table contain 5 column id,data,storage,bandwidth_sent, bandwidth_received , like this : http://pastebin.com/ghXWMZ7V. The storage and bandwidth information is accumulated one. I need to fetch my daily usage from data bases. I need to subtract today's storage -yesterday storage bases on date .Here id is same. I am new to witting mysql query (learning). I think this can be done using sub query. any help will be really appreciated .
Thanks & Rg Mohan L