1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

List all results except the biggest?

Discussion in 'SQL - Questions and Answers' started by alexfr, May 24, 2006.

  1. alexfr New Member

    Dialect: MySQL
    List all results except the biggest
    alexfr, May 24, 2006
    #1

  2. alexfr New Member

    Dialect: MySQL
    SQL:
    SELECT * 
    
FROM orders
    
where id < (select MAX(id)
    
                  from orders)
    
ORDER BY id DESC
    alexfr, May 24, 2006
    #2

  3. Unregistered Guest

    SQL:
    select(*)
    
from table
    
where column not in
    
(select max(column)
    
from table);
    Unregistered, Jul 24, 2008
    #3

Share This Page