数据库：COUNT() 函数的使用（头歌）

USE MallGOSET NOCOUNT ON------ return the number of product which price bigger than 10 ------- ********** Begin ********** --SELECT COUNT(prod_price)FROM ProductsWHERE prod_price>10-- ********** En

零小唬

2105人浏览 · 2022-05-22 10:47:38

零小唬 · 2022-05-22 10:47:38 发布

USE Mall
GO

SET NOCOUNT ON

------ return the number of product which price bigger than 10 -----
-- ********** Begin ********** --
SELECT COUNT(prod_price) 
FROM Products
WHERE prod_price>10
-- ********** End ********** --

GO