Select * >From content LIMIT 1 vs.
Select top 1 >From content IIRC Different DBMS, some use LIMIT 1, some use TOP 1 and another uses something different. http://dotnet.org.za/thea/archive/2005/02/22/14715.aspx SQL SELECT TOP N equivalent in ORACLE and MySQL Something I needed today... I wish this was standarized, but it is not, so here are some examples: SQL Server: SELECT TOP 10 product, descr, email FROM products ORACLE: SELECT product, descr, email FROM products WHERE ROWNUM <= 10 MySQL: SELECT product, descr, email FROM products LIMIT 10 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2844 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
