Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- COUNT(*) OVER () AS TotalRowsFound,
- t.Title
- , t.ItemID
- , t.UploadDate
- , t.SevenDaySales as SelectedColumnSales
- , t.QuantitySold
- , t.CurrentPrice
- , t.CurrentPrice as LastSalePrice
- FROM
- dbo.SearchedUserItems t
- WHERE
- T.SearchedUserID = 5
- GROUP BY
- t.ItemID,t.UploadDate,t.SelectedColumnSales,t.QuantitySold,t.CurrentPrice,LastSalePrice
- ORDER BY SelectedColumnSales DESC
- OFFSET + 55*0 ROWS FETCH NEXT 55 ROWS ONLY;
Add Comment
Please, Sign In to add comment