MySQL Forums :: Newbie :: Query to find difference between data


Advanced Search

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 Robert Mackinzie 10/17/2011 12:05PM
Re: Query to find difference between data laptop alias 10/17/2011 03:08PM
Re: Query to find difference between data Rick James 10/20/2011 07:51AM


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.