如何在SQL中连续排序奇数和偶数行数?例如,对于一个有五行的表:
行号 | 值 | 2 | 4 |
---|---|
B | |
C | |
3 | D |
E |
使用order by子句
select column1
from table
order by mod(column1, 2),
column1;
MOD(n2, n1): MOD返回n2除以n1的余数(在Oracle中)。
select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp);
奇数:
偶数:
select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);