Getting previous record from Max

[morfasie]

Hi if I have a table

Transid Balance Date
------------------------------
1 10 2004-10-01
40 430 2004-10-12
230 32 2004-10-15
255 1123 2004-10-25
------------------------------

If I get the Max(TransID) I get 255, but I want the previous one 230?

How do I get that one?

 

[PHV]

Have you tried this ?
SELECT Max(TransID) FROM YourTable
WHERE TransID<(SELECT Max(TransID) FROM YourTable)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[morfasie]

Thank You

Martin