Question:How do you select a single random row from a table? 

A SELECT random() * FROM tab LIMIT 1; 

B SELECT * FROM tab ORDER BY random() LIMIT 1; 

C SELECT * FROM tab RANDOM LIMIT 1 ; 

D SELECT RANDOM 1 from tab; 

E None of these 

+ Answer
+ Report
Total Preview: 831

Copyright © 2024. Powered by Intellect Software Ltd