请一个DB2取随机记录的SQL

[a2bb]

DB2如何在一个表中取随机的N条记录啊
就是相当与sql server的select top 10 * from tablename order by newid()
或者oracle的

select *from (select *from t order by dbms_random.value) where rownum<10;

[Mr_Bean]

select * from tablename order by rand() fetch first n rows

[Mr_Bean]

only

[jin_ok]

select * from tablename order by rand() fetch first n rows only;

[王帆]

蛮有意思！顶一下

[littleboys]

select * from (select ROW_NUMBER() OVER() as rownum from test) as t where t.rownum<10;

[conannb]

顶一下