You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
7 lines
328 B
7 lines
328 B
|
|
|
|
|
|
create proc HotProductShow_Select
|
|
as
|
|
select top 6 ProdID,ProdName,ProdPrice,ProdDiscount,ProdIMG,ProdDate,sum(ODProdNum) as ProdSum from dbo.Product,dbo.OrderDetails where dbo.OrderDetails.ODProdID=dbo.Product.ProdID and ProdIsDeleted=1 group by ProdID,ProdName,ProdPrice,ProdDiscount,ProdIMG,ProdDate order by ProdDate desc
|