sql查询条件学习
1、现创建表和初始化数据：
CREATE TABLE student (
student_id int (11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
student_name VARCHAR (20) CHARACTER SET utf8 NOT NULL,
student_sex VARCHAR (2),
student_age INTEGER (3),
dept_id VARCHAR (2),
class_id VARCHAR (8)
);
CREATE TABLE course (
course_id int (11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
course_name VARCHAR (40) CHARACTER SET utf8 NOT NULL,
course_hours INTEGER (2),
course_credit FLOAT (1)
);
create TABLE grade(
grade_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
student_id INT(11) NOT NULL,
course_id int(11) NOT NULL,
grade_val DOUBLE
);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Tom','M',18);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Jar','M',17);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Mary','G',18);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Tim','G',16);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Sala','G',18);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Miki','G',19);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Jack','M',18);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Sar','G',17);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Lide','G',18);
INSERT INTO student (student_name,student_sex,student_age) VALUES('Bill','M',17);
INSERT INTO course (course_name) VALUES('英语');
INSERT INTO course (course_name) VALUES('语文');
INSERT INTO course (course_name) VALUES('数学');
INSERT INTO grade(student_id,course_id,grade_val) VALUES(1,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(2,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(3,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(4,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(5,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(6,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(7,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(8,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(9,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(10,1,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(1,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(2,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(3,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(4,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(5,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(6,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(7,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(8,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(9,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(10,2,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(1,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(2,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(3,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(4,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(5,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(6,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(7,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(8,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(9,3,80);
INSERT INTO grade(student_id,course_id,grade_val) VALUES(10,3,80);
2、查询表的记录但不需要显示重复的记录，使用distinct，如图
3、对于多张表查询，同时满足条件两个或多个条件结合起来的记录需要使用and
4、如果查询的结果要求只要有一个成立就可以，可以使用OR,如图
5、把相同值分成一组，可以使用Group BY来实现，如图
6、如果需要对值进行排序，可以使用ORDER BY,如图
