3 Replies Latest reply on Jun 22, 2015 11:11 AM by derhally

    how to count the remainding rows

    rawwinton

      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