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

    how to count the remainding rows




      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