Help for this page

Select Code to Download


  1. or download this
      SELECT id, total
        FROM some_table
       WHERE id > (SELECT MAX(id) FROM some_table) - 10
    ORDER BY total DESC
    
  2. or download this
      SELECT id, total
        FROM some_table
       WHERE id > (SELECT MAX(id) - 10)
    ORDER BY total DESC