Re: Variable in LIMIT clause

[Karl Seguin]

Matthew, there's something you don't get. While I completely agree that SQL Server should add a LIMIT statement - and have stated so before publically (http://codebetter.com/blogs/karlseguin/archive/2006/04/17/142964.aspx), the reality is that you aren't making a fair comparison at all.

The ROW_NUMBER() OVER functionality of SQL Server 2005 is just one of the MANY ranking functions available. Sure, it might be a nuisance to do simple ranking in SQL Server (and again, I do hope they fix it), but it's IMPOSSIBLE to do any of the many other types of ranking in MySQL. With that said, no amount of minor tweaks to LIMIT will ever put MySQL's ranking capabilities ahead of anyone.

If you spend your time doing a website and trying to page results, I totally agree with you. But if you step back from it and look at it at a higher level, I think the total reverse of what you said is true.