1.选择points大于3000 信息,greater than
2.>,<,>=,<=,=,!=or <>(not equal)
3.va大小学没影响,
where state<>'VA'或者
where state!='VA'
4.名称注意不要写错了
5.练习:get the orders placed the year 2019,2019年的订单情况
select *
from orders
where order_date>='2019-01-01'
1.选择points大于3000 信息,greater than
2.>,<,>=,<=,=,!=or <>(not equal)
3.va大小学没影响,
where state<>'VA'或者
where state!='VA'
4.名称注意不要写错了
5.练习:get the orders placed the year 2019,2019年的订单情况
select *
from orders
where order_date>='2019-01-01'