MySQL Forums
Forum List  »  Newbie

Query to find difference between data
Posted by: Robert Mackinzie
Date: October 17, 2011 12:05PM

Let's say I have a table, it shows each server along with the table size for each day. I need to know how big the table is in lines today, vs. yesterday, day before, etc.

So my rows look like:
SERVER | TABLE | SIZE | DATESTAMP
FTL-DB1 Concord 151162 10-14-2011
FTL-DB1 Concord 157219 10-15-2011
FTL-DB1 Concord 159203 10-16-2011
FTL-DB1 Concord 206001 10-17-2011

I want to see the difference between each date (specifying date in query) and I want to know the average increase in lines over all of date period specified.

Can someone help me with that?

Options: ReplyQuote


Subject
Written By
Posted
Query to find difference between data
October 17, 2011 12:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.