MySQL Bugs: #5984: SELECT TOP xxx

Bug #5984	SELECT TOP xxx
Submitted:	8 Oct 2004 15:44	Modified:	6 Feb 2006 10:16
Reporter:	Viktor Kaydalov	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	4.1.5	OS:
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
SELECT TOP ... to SELECT ... LIMIT translation.

How to repeat:
It would be nice and not so difficult to add translation of 
SELECT TOP <xx> ...
 sinax to 
SELECT ... LIMIT <xx>
 for MS SQL compatibility.
About SELECT TOP sintax see at
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sa-ses_9sfo.asp

Thank you for a feature request. Sorry, but I do not think that this feature is needed (it is yet another way to get "first rows", as you noted), even taking into account the fact that it can simplify migration from MS SQL. There are many more serious problems during this migration, besides slightly different SELECT syntax.