警惕:一条直接让数据库服务器挂机的查询SQL
Create table t_document(id integer);
select
rownumber() over(order by
id,id desc
) as rownumber_
from
t_document
order by id,id desc
写hql时，不小心对同一条件排序了两次！大家可以试试！！
幸好发现及时，否则上了生产后果不堪设想啊！
17同行回答
没问题 (9.7):
db2 => create table t_document(id integer)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
0 record(s) selected.
db2 => insert into t_document values (1)
DB20000I The SQL command completed successfully.
db2 => insert into t_document values (2)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
1
2
2 record(s) selected.收起
db2 => create table t_document(id integer)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
0 record(s) selected.
db2 => insert into t_document values (1)
DB20000I The SQL command completed successfully.
db2 => insert into t_document values (2)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
1
2
2 record(s) selected.收起
浏览1113