sql语句拼接，字符截取，sql排序

1、下面的语句会把，从t_in_1表查询的vinLeft字段进行去重，同理t_vin_3 做同样的处理，并且把两个查询的结果连在一起

SELECT DISTINCT(vinLeft) FROM t_vin_0 UNION SELECT DISTINCT(vinLeft) FROM t_vin_1
UNION
SELECT DISTINCT(vinLeft) FROM t_vin_2 UNION SELECT DISTINCT(vinLeft) FROM t_vin_3

2、sql语句中匹配以什么结尾的写法
SELECT * FROM check_table WHERE right(vinLeft,1)  regexp '[A-Z]';
3、不是以大写字母结尾的
SELECT * FROM check_table WHERE right(vinLeft,1)  not regexp '[A-Z]';
4、sql截取字符串长度并拼接 两种写法
select concat(substr(vinLeft,1,8),substr(vinLeft,10,2)) vinstr from check_table;
select concat(SUBSTR(vinLeft FROM 1 FOR 8),SUBSTR(vinLeft FROM 10 FOR 11)) vinstr from check_table;
select count(DISTINCT(b.vinstr)) FROM(select concat(SUBSTR(vinLeft FROM 1 FOR 8),SUBSTR(vinLeft FROM 10 FOR 11)) vinstr from check_table) as b;

5.SQL排序

DESC降序排列，
默认升序排列
select * from room  where uid='1329907' order by addtime DESC
根据 “列” 从小到大排列
select * from 表 order by 列 asc
根据 “列” 从大到小排列
select * from 表 order by 列 desc
根据 “列1” 从大到小排列，如果相同则按列2从小到大排序
select * from 表 order by 列1 desc,列2 asc