Unfortunately, it first takes the number of records you LIMIT and then sorts those. Would a select with MAX do what you want?
Bill Cook Kent WA USA ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2001 12:59 PM Subject: Limit = with Order by Desc > RB 65 Win/Dos. If I want to do a select or chose on a dataset say based on > an Int or Date col in descending order Then limit the number of selections > with Limit = , the expected result would be the highest value Int or Date, > but this is not the result. The workaround is a Temp View, etc. > > >
