select选出表格
select store-name from stroe-information
distinct读取不同资料
select distinct store-name from stroe-information
where选择性抓取资料
select store-name from store-information where sales》1000
and or组合简单条件
select stroe-name from store-information where sales》1000 or(sales《500 and sales》275)
in在不连续的值内抓已知数据
select* from stroe-information where store-name in(‘los’,‘san’)
between在一个范围内抓已知数据
select* from store-informaion where date between ‘jan’ and ‘mar‘
like依据模式找资料
order by 排列资料
select store-name,sales,date from store-information order by sales DESC