1、查找lianxi3表,成绩在80-100区间的学生
select * from lianxi3 where grade between 80 and 100
2、查找lianxi2表,id为2,11,12的数据
select * from lianxi2 where id in(2,11,12)
1、查找lianxi3表,成绩在80-100区间的学生
select * from lianxi3 where grade between 80 and 100
2、查找lianxi2表,id为2,11,12的数据
select * from lianxi2 where id in(2,11,12)