Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

Browse by Tags

All Tags » SQL » self join

  • PL-SQL: Returning a value from the previous row in a query

    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 ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on January 24, 2007
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems