This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

how to count the remainding rows

Hi,

Is SQWL able to return me the number of rows of the products not in the top few entries i.e.

select top 3 vendors ...

but the result I want is

Vendor A-5000

Vendor B- 3000

Vendor C- 1000

others - 2000

rawwinton