Thanks! was: top 10 is not a field

I do thank all of you guys for responding to this. We run an Oracle 7 database on a Unix machine where all of our school records and such are stored. To input this information we use a product called Banner by SCT. I use Cold Fusion and O'Reilly WebSite on NT 2000 to dynamically display informa

Re: top 10 is not a field

> 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 respo

Re: top 10 is not a field

<= B.Salary) GROUP BY A.salary HAVING COUNT(*) <= 3 // change this for top n JustinMacCarthy - Original Message - From: "Patricia Lee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 20, 2000 1:18 PM Subject: RE: top 10 is n

RE: top 10 is not a field

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 i

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 m