Re: (OT) MySQL query to limit and sort

UPDATE: Sorry I put a broken query... here is the fixed one:

  SELECT id, total
    FROM some_table
   WHERE id > (SELECT MAX(id) FROM some_table) - 10
ORDER BY total DESC
[download]

(old one here for historical purposes):

  SELECT id, total
    FROM some_table
   WHERE id > (SELECT MAX(id) - 10)
ORDER BY total DESC
[download]

Comment on Re: (OT) MySQL query to limit and sort Select or Download Code

Replies are listed 'Best First'.
Re^2: (OT) MySQL query to limit and sort by Anonymous Monk on Feb 03, 2006 at 22:40 UTC
Using that I don't get any rows back. `my $data = qq[SELECT id, url, images, Total FROM temp WHERE id > (SEL +ECT MAX(id) - 10) ORDER BY Total DESC];` [download]	[reply] [d/l]
Re^3: (OT) MySQL query to limit and sort by saberworks (Curate) on Feb 03, 2006 at 22:47 UTC
Apologies: `SELECT id, total FROM some_table WHERE id > (SELECT MAX(id) FROM some_table) - 10 ORDER BY total DESC` [download]	[reply] [d/l]
Re^4: (OT) MySQL query to limit and sort by rhesa (Vicar) on Feb 03, 2006 at 23:01 UTC
It's slightly fragile in the face of deletions. Say you have records 140 through 160, delete 150 through 159, then run this query. That will only return record 160, while I would expect (141 .. 149, 160). But that may just be my interpretation of the OP's question asking for a top 10.	[reply]