数据检索.sql

来自「简单的sql语句 数据与汇总。 高手多多指点。」· SQL 代码 · 共 32 行

use northwind

select productid,productname,supplierid,categoryid from products

select productid,productname from products
where productid=5

select * from [order details]
where orderid >= 10256

select * from products
where productname like 'qu%' or productname like'ch%'

select * from products
where productid in(1,2,3,4,5,6,8,9,10,11)and productname like 'c%'

select * from products
where productid between 1 and 5

select * from products
where productid in(1,5,6)

select * from suppliers
where fax is null and region is null and homepage is null

select* from suppliers 
where fax is not null

select distinct region from suppliers
order by region