去重——DISTINCT
字符串连接
SELECT name || ‘’’’ || ‘s 编号 is ‘ || id FROM student;
//四个连续的单引号是为了可以输出一个单引号
b) CONCAT
SELECT CONCAT(CONCAT(name , ‘’‘s 编号 is ‘), id) FROM student;
子查询
1) UNION——并(有DISTINCT的并)
SELECT * FROM student
UNION
SELECT * FROM student1
2) INTERSECT——交
SELECT * FROM student
INTERSECT
SELECT * FROM student1
3) MINUS——差
SELECT * FROM student
MINUS
SELECT * FROM student1
查询结果为student中有student1中没有的数据
4) UNION ALL——并(无DISTINCT的并)
SELECT * FROM student
UNION ALL
SELECT * FROM student1