How to get the previous ID

[sonaliak]

How about this..


Select max(MessageID) from Message
where MessageID <( Select max(MessageID) from message);

and


Select max(MessageID) + 1 from Message;