首先 数据表的结构如下:
id name type date1 a 1 214-09-10
2 b 0 214-09-11
3 c 1 214-09-22
4 d 0 214-09-23
5 e 1 214-09-24
6 f 0 214-09-25
想得到的结果是
id name type date6 f 0 214-09-25
4 d 0 214-09-23
5 e 1 214-09-24
3 c 1 214-09-22
2 b 0 214-09-11
1 a 1 214-09-10请问大神们sql怎么写??
id name type date1 a 1 214-09-10
2 b 0 214-09-11
3 c 1 214-09-22
4 d 0 214-09-23
5 e 1 214-09-24
6 f 0 214-09-25
想得到的结果是
id name type date6 f 0 214-09-25
4 d 0 214-09-23
5 e 1 214-09-24
3 c 1 214-09-22
2 b 0 214-09-11
1 a 1 214-09-10请问大神们sql怎么写??
union all
select * from tb where name not in ('f','d') order by id desc
例如 : 上面的例子加强
id name type date
1 a 1 214-09-10
2 b 0 214-09-11
3 c 1 214-09-22
4 d 0 214-09-23
5 e 1 214-09-24
6 f 0 214-09-25
7 f1 0 214-10-01
8 f2 1 214-10-02
9 f3 0 214-09-29
我想得到的结果id name type date
// 这里是根据 type =0 order by date desc limit 2排序
7 f1 0 214-10-01
9 f3 0 214-09-29
// 这里是根据 order by date desc 除了以上两个的所有排序
8 f2 1 214-10-02
6 f 0 214-09-25
5 e 1 214-09-24
4 d 0 214-09-23
3 c 1 214-09-22
2 b 0 214-09-11
1 a 1 214-09-10这两句能合成一句吗??
union all
select * from tablename where id not in (select id from tablename where type =0 order by date desc limit 2) order by date desc
tablename
order by (id in (select id from tablename where type =0 order by date desc limit 2)) desc, date desc
老大 报错 #1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'