No, TOP is not standard SQL. It is an extension available in some SQL
implementations.
Earlier this month Chris Lott posted two queries which produce the same
result, one using TOP and one not (and hence quite a bit longer). He'd
asked for comments, but I don't recall seeing any.
-David
On Fri, 20 Oct 2000 08:18:11 -0400 Patricia Lee <[EMAIL PROTECTED]>
writes:
> Top 10 IS a SQL Command. I copied this statemtent directly from my
> SQL 7
> Enterprise manager if you still don't believe:
>
> SELECT TOP 10 *
> FROM [dbo].[objects]
>
> It returns the top 10 rows, all columns.
>
> -----Original Message-----
> From: Jim Watkins [mailto:[EMAIL PROTECTED]]
> Subject: top 10 is not a field
>
>
> I noticed when I posted my question on "selecting the top ten of a
> list of
> counties" that 2 or 3 responded with something like: "Select top 10
> * (or
> your fields)" now how would CF and Oracle respond to such a
> statement as
> 'top ten' as it is not a SQL command (as far as I know) or even a
> field in
> my query?
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
