Is there a way to get "the rest" of a list? I have a TopN filter
working on one table showing the top 3 results. Now, I have another
table that I want to show everything but the top 3. This table will be
hidden by default, but that shouldn't matter. Is there a way to get
"not TopN =3"?
Also, how would I get the first 3, instead of top 3? My results would
be pre-sorted coming from the datasource and I just want to show the
first few rows.
ThanksAre you using a stored procedure? You could use a correlated subquery. For
example: select bookid from books where bookid not in (select top 3 bookid
from books).
"Steven" wrote:
> Is there a way to get "the rest" of a list? I have a TopN filter
> working on one table showing the top 3 results. Now, I have another
> table that I want to show everything but the top 3. This table will be
> hidden by default, but that shouldn't matter. Is there a way to get
> "not TopN =3"?
> Also, how would I get the first 3, instead of top 3? My results would
> be pre-sorted coming from the datasource and I just want to show the
> first few rows.
> Thanks
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment