desc, limit 1

BEFOR

SELECT *
FROM Bbat
WHERE Bbat.BID = colname AND
Bbat.BID < (select max (Bbat.BID) FROM Bbat) ORDER BY Bbat.BID desc limit 1

It seems this should work to retrieve the next to the last row, but it doesn't. (syntax errors) How else could I get it?

mrhappiness

SELECT *
FROM Bbat
WHERE Bbat.BID = colname 
ORDER BY Bbat.BID desc limit 1,1

BEFOR

thanks mrhappiness,

Works nice. I'm curious how this breaks out "desc limit 1,1 "

x,x -what each means.

Is is possible to bring the third from the last, and so on?

tomhath

Third from the last should be DESC LIMIT 2, 1 which means offset 2 rows then return 1

If you only give it one number it's equivalent to LIMIT 0,x (offset 0 rows, then return the next x).

http://dev.mysql.com/doc/mysql/en/select.html

BEFOR

what if there is a join and I need to order by two sep desc limit 1's:

ORDER BY Bbat.ID DESC limit 1
ORDER BR Cbat.ID DESC limit 1

SELECT *
FROM Bbat, Cbat
WHERE Bbat.BID = Cbat.BID and Cbat.BID=colname

mrhappiness

ORDER BY column_A DESC, column_B DESC
LIMIT 1,1

BEFOR

thanks.

let me explain what I'm doing. i have a table with repeat rows of column_A (history table) where the values may change over time. I need to evaluate where :

empty($row['column_A ']) //assuming Bbat or Cbat contains column_A
!empty ($row['column_A '])

Using '0' inserted as default which should evaluate as empty.
Some early rows have '0' while later rows have numeric values.

These are joined by a column in-common like:

SELECT *
FROM Bbat, Cbat
WHERE Bbat.mID = Cbat.mID and mID = colname

//where colname is a session variable.

But with DESC 1,1 whenever there is a '0'//empty on ANY column (former row) the DESC 1,1 is not being adhered to.

How can I make the last row only be evaluated?