准备条件
create table exam(<br> id int primary key auto_increment,<br> name varchar(20),<br> english int,<br> chinese int,<br> math int<br>); <br>insert into exam values (null,'张三',85,74,91);<br>insert into exam values (null,'李四',95,90,83);<br>insert into exam values (null,'王五',85,84,59);<br>insert into exam values (null,'赵六',75,79,76);<br>insert into exam values (null,'田七',69,63,98);<br>insert into exam values (null,'李老八',89,90,83);
范围查询
select * from exam where english in (69,75,89); （查询范围在english中的69,75,89）
分组查询
准备
create table item(<br> id int primary key auto_increment,<br> product varchar(20),<br> price double<br>);<br>insert into item values (null,'电视机',2999);<br>insert into item values (null,'电视机',2999);<br>insert into item values (null,'洗衣机',1000);<br>insert into item values (null,'洗衣机',1000);<br>insert into item values (null,'洗衣机',1000);<br>insert into item values (null,'冰箱',3999);<br>insert into item values (null,'冰箱',3999);<br>insert into item values (null,'空调',1999);
语法
