SQL SELETE

SELECT

-- 查询数据
SELECT studentno, studentname, email
FROM student
WHERE majorid = 2;


		    

-- 去重查询
SELECT DISTINCT sex
FROM student;
		    

-- 查询
SELECT *
FROM student
WHERE age BETWEEN 20 AND 30;

SELECT *
FROM student
WHERE studentname LIKE '张%';
		    

-- 查询 排序
SELECT *
FROM student
ORDER BY age ASC;

-- 查询 降序
SELECT *
FROM student
ORDER BY age DESC;
		    

-- 查询 分组
SELECT COUNT(*),sex
FROM student
GROUP BY sex
HAVING sex = '女';