数据库：使用WHERE语句进行检索（头歌）

USE MallGoSET NOCOUNT ON---------- retrieving with range ------------ ********** Begin ********** --select prod_name,prod_pricefrom Productswhere prod_price between 3 and 5-- ********** End **********

零小唬

1721人浏览 · 2022-05-22 10:28:43

零小唬 · 2022-05-22 10:28:43 发布

USE Mall
Go

SET NOCOUNT ON

---------- retrieving with range ----------
-- ********** Begin ********** --
select prod_name,prod_price
from Products
where prod_price between 3 and 5


-- ********** End ********** --

GO

---------- retrieving with nomatches ----------
-- ********** Begin ********** --
select prod_name,prod_price
from Products
where prod_name!='Lion toy'


-- ********** End ********** --

GO