aaghoasten
New Member
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. \[code\]SELECT * FROM JAVA2.FORTUNES ORDER BY RANDOM()\[/code\]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. 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). Is there a Java DB specific, or ANSII standard way to return a single row using the above syntax?