Thread: List all results except the biggest?
View Single Post
  #2 (permalink)  
Old 05-23-2006, 11:58 PM
alexfr alexfr is offline
Junior Member
  
Join Date: May 2006
Posts: 24
alexfr is on a distinguished road
Default MySQL answer. Re: List all results except the biggest?
[sql]SELECT *
FROM orders
where id < (select MAX(id)
from orders)
ORDER BY id DESC[/sql]
Reply With Quote