select t.id from (select id from table where id between 1 and 1 desc) a ,table t where t.id between 10 and 20 asc 试一试看看行不行
为什么会有这样的应用,说一下用来做什么的,或许有其他的方法。 如果是限定了只有20个的话用这个: --初步 SELECT * FROM tb WHERE id > 0 AND id <11 ORDER BY id DESC UNION SELECT * FROM tb WHERE id > 10 AND id <21 ORDER BY id ASC
不行,分两次查询。 另外,这个笔试可能不是考sql,而是数组排序。
执行:SELECT * FROM tb WHERE id > 0 AND id <11 ORDER BY id DESC 处理数据。 执行:SELECT * FROM tb WHERE id > 10 AND id <21 ORDER BY id ASC 处理数据 数组内排序,就: SELECT * FROM tb WHERE id > 0 AND id <21 ORDER BY id DESC 将结果保存进数组,根据ID进行筛选排序,最后输出。
根據id倒敘排列 order by id desk根據id正序排列 order by id asc例如 select * from usertable where id <100 order by id desc
where t.id between 10 and 20 asc 试一试看看行不行
如果是限定了只有20个的话用这个:
--初步
SELECT * FROM tb WHERE id > 0 AND id <11 ORDER BY id DESC
UNION
SELECT * FROM tb WHERE id > 10 AND id <21 ORDER BY id ASC
另外,这个笔试可能不是考sql,而是数组排序。
处理数据。
执行:SELECT * FROM tb WHERE id > 10 AND id <21 ORDER BY id ASC
处理数据
数组内排序,就:
SELECT * FROM tb WHERE id > 0 AND id <21 ORDER BY id DESC
将结果保存进数组,根据ID进行筛选排序,最后输出。
order by id desk根據id正序排列
order by id asc例如
select * from usertable where id <100 order by id desc