blogs.conchango.com

For any number of reasons which I won’t go into, you may have a need, or desire, to return a value in a query from one row next to a value from another. A typical example might be in a daily sales database, where I want to see yesterday’s total sales against today’s total sales. It is straight forward enough to write the query to ...