Avoid Multiple Queries When Querying for Max and Min Values
        Posted  
        
        on Internet.com
        
        See other posts from Internet.com
        
        
        
        Published on Tue, 11 Aug 2009 04:00:00 +010
        Indexed on 
            2010/03/07
            23:13 UTC
        
        
        Read the original article
        Hit count: 505
        
Filed under: 
        Instead of making one query to get the Max and Min values for a column, and then making another query to get additional information about those rows, you can do it all in one query.
        
        © Internet.com or respective owner