Hello everyone I have created two select statements but I want to merge them together to give one select statement that display only 4 record can someone help please?
SELECT
DATENAME(month, BID.Date) AS Years,
COUNT(DATENAME(Month, BID.Date)) AS Total
FROM
Auction
INNER JOIN
BID ON Auction.AuctionID = BID.AuctionID
INNER JOIN
Item ON Auction.ItemID = Item.ItemID
WHERE
(Auction.Status = 'Expired')
AND (Item.SellerID = @seller)
AND (BID.Status = 'Won')
GROUP BY
DATENAME(month, BID.Date)
SELECT
DATENAME(month, BID.Date) AS Years,
COUNT(DATENAME(Month, BID.Date)) AS Total
FROM
Auction
INNER JOIN
BID ON Auction.AuctionID = BID.AuctionID
INNER JOIN
Item ON Auction.ItemID = Item.ItemID
WHERE
(Auction.Status = 'UnSold')
AND (Item.SellerID = @seller)
GROUP BY
DATENAME(month, BID.Date)
Go to the complete details ...