Guest User

Untitled

a guest
Apr 23rd, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. SELECT
  2. COUNT(*) OVER () AS TotalRowsFound,
  3. t.Title
  4. , t.ItemID
  5. , t.UploadDate
  6. , t.SevenDaySales as SelectedColumnSales
  7. , t.QuantitySold
  8. , t.CurrentPrice
  9. , t.CurrentPrice as LastSalePrice
  10.  
  11. FROM
  12. dbo.SearchedUserItems t
  13. WHERE
  14. T.SearchedUserID = 5
  15. GROUP BY
  16. t.ItemID,t.UploadDate,t.SelectedColumnSales,t.QuantitySold,t.CurrentPrice,LastSalePrice
  17. ORDER BY SelectedColumnSales DESC
  18. OFFSET + 55*0 ROWS FETCH NEXT 55 ROWS ONLY;
Add Comment
Please, Sign In to add comment