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

Find more posts tagged with

I'm guessing you are looking for node count by vendor. If that's the case, a query like this will work:

SELECT Vendor, COUNT(1) AS QuantityFROM Orion.NodesGROUP BY Vendor

Pro tip: these kinds of questions will be answered more quickly if posted in the Orion SDK forum.

No I was looking to count the number of products by other vendors other than the top 3 resulting a display in 4 rows (top3 + others)

You are referring to the ROLLUP functionality and we currently do not support that in SWQL.