sql语句
SELECT DISTINCT sname FROM student;
SELECT sname FROM student LIMIT 5 OFFSET 1;
SELECT sname FROM student LIMIT 1,5;
SELECT * FROM student ORDER BY sname DESC,sex;
UPDATE student SET sex = ‘m’ WHERE id = 20130019;
SELECT * FROM student ORDER BY sname ;
SELECT * FROM student WHERE age4 =2 ORDER BY sname;
SELECT * FROM student WHERE age3 = 2 OR age4 IS NULL;
SELECT * FROM student WHERE sname LIKE ‘%w%’;
SELECT * FROM student WHERE sname REGEXP ‘[l|i]s’;
SELECT CONCAT(sname,’ sex = ',RTRIM(sex),‘end’) AS con FROM student ORDER BY sname;
SELECT FROM student WHERE DATE(DATE) = ‘2018-09-12’;
SELECT * FROM student WHERE DATE(DATE) BETWEEN ‘2018-08-01’ AND ‘2018-09-10’;
SELECT MIN(age3)AS AvgAge FROM student;
SELECT id ,COUNT() FROM student GROUP BY sname HAVING COUNT() >= 1 ORDER BY COUNT() DESC