如何在Netbeans JavaDB中使用SQL RANDOM()函数 [英] How to use the SQL RANDOM() function in a Netbeans JavaDB
问题描述
我需要在Netbeans 7.2中的一个小型本地JavaDB中进行SQL调用,从数据库中提取一个随机行。
I need to do a SQL call in a small local JavaDB in Netbeans 7.2 to pull a single random row from the database.
SELECT * FROM JAVA2.FORTUNES ORDER BY RANDOM()
到目前为止,我已经使用RANDOM()函数工作,但是我无法使LIMIT 1工作,它会返回语法错误。
So far, I've got it to work using the RANDOM() function, but I'm having trouble getting LIMIT 1 to work, it returns a syntax error.
我知道每个数据库都有不同的方法来做这个,我无法弄清楚它是如何专门为Netbeans中的这个JavaDB工作的(我让它工作了在具有不同语法的单独Oracle DB中)。
I know that every database has a different way to do this, and I can't figure out how it works specifically for this JavaDB in Netbeans (I got it to work in a separate Oracle DB with different syntax).
是否有使用上述语法返回单行的Java DB特定或ANSII标准方法?
Is there a Java DB specific, or ANSII standard way to return a single row using the above syntax?
推荐答案
Java DB使用SQL的OFFSET / FETCH语法来获得此功能。
Java DB uses SQL's OFFSET/FETCH syntax to get this functionality.
假设RANDOM()正确地命令它们,以下语法应该有效:
Assuming RANDOM() orders them correctly the following syntax should work:
SELECT * FROM JAVA2.FORTUNES ORDER BY RANDOM() OFFSET 0 ROWS FETCH NEXT 1 ROW ONLY
这篇关于如何在Netbeans JavaDB中使用SQL RANDOM()函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!