I'm working on a client site and there was a small piece of a query that I've never seen. After the query itself there was the text "limit 1". I assume this is a limiter on the query to return only 1 row. If so, then why did they not use "top 1" inside the query? Is there a difference?
Select * >From content LIMIT 1 vs. Select top 1 >From content ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2842 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
