Re: Limiting the amount of rows
From: David Gugick (davidg-nospam_at_imceda.com)
Date: 09/23/04
- Next message: Mark: "Sequel query retrieves duplicate data"
- Previous message: SQLScott: "Linked Tables to Foxpro database on Windows 2003"
- In reply to: Hugo Kornelis: "Re: Limiting the amount of rows"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 23 Sep 2004 10:45:01 -0400
Hugo Kornelis wrote:
> On Wed, 22 Sep 2004 18:59:03 -0700, MTKIRWAN wrote:
>
>> However I want the result set to list the top 10 records. This could
>> be done using the top 10 function. However as you can see Attribute
>> value 10 and 11 both have the total of 2 and are therefore
>> equilvalent. So I really want the top 11 returned in this case. If
>> Attribute value 12 had been 2 then I would have wanted the top 12 etc
>>
>> How can I do this?
>
> TOP 10 WITH TIES
>
> ?
>
> Best, Hugo
I guess you learn something every day. Never knew.
-- David Gugick Imceda Software www.imceda.com
- Next message: Mark: "Sequel query retrieves duplicate data"
- Previous message: SQLScott: "Linked Tables to Foxpro database on Windows 2003"
- In reply to: Hugo Kornelis: "Re: Limiting the amount of rows"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
