mattj@stripped wrote:
>
> I noticed something in the currently posted crash-me results (at
> http://www.mysql.com/crash-me-get.htmy).
>
> Under "Expression Limits", mySQL supports "SELECT with LIMIT", and SQL
> Server 7.0 does not. However, it should be added that SQL Server does
> support *this* syntax:
>
> SELECT TOP 200 mycolumn FROM mytable ...
>
> [The crash-me page gives results from mySQL 3.23.12, and I don't yet have
> a newer version than that installed, but the change history
> (http://www.mysql.com/Manual_chapter/manual_News.html) doesn't mention
> support for TOP, so I figure I'm safe in pointing this out :-) ]
>
> Also, I rarely write to this list, so let me take a second to thank
> everyone, especially the mySQL developers, for providing such outstanding
> support. Although I don't currently use mySQL in my day job, I can
> justify the time I spend reading this list because of all the tips on
> database design, application design, and query optimization. Then at home
> I can use the mySQl-specific stuff. Thanks!
>
> -Matt Jensen
> NewsBlip
> Seattle
>
> (NewsBlip runs on mySQL)
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread33560@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-tonu=mysql.com@stripped>
--
+----------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel |
| /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------+
| Thread |
|---|
| • Re: crash-me: LIMIT vs. TOP | Tonu Samuel | 8 Apr |
