sql LIMIT rows in version 4.1 1

[Kris91261]

I've used the LIMIT function in mySql 5.0 with no problem. Such as:
sql = "select * from Events order by EventDate DESC, 'LIMIT 0,3'"

I have tried to use the same query on a mySql 4.1.22 server and I don't get an error but it doesn't adhere to the LIMIT part of the query.

Any ideas on a way to pull four rows from a table without the LIMIT function? I want the four most recent entries in the table.

I would appreciate any help you could give.

Thanks,
Kris91261

 

[SQLSister]

In SQL Server I would use
select top 3 * from Events order by EventDate DESC

I have no idea what My SQl would require. I would suggest you repost in the My SQL forum. This one is dedicated to Microsoft SQL Server.

"NOTHING is more important in a database than integrity." ESquared

 

[SQLDenis]

Maybe if you posted in the MySQL forum you will get a quick and corrct answer

http://www.tek-tips.com/threadminder.cfm?pid=436

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions