随机获取一条记录,以下哪个语句是正确的?
(A)select rand from posts;
(B)select rand(*) from posts;
(C)select rand(*) from posts LIMIT 1;
(D)select * from posts ORDER BY rand() LIMIT 1;
参考答案
继续答题:下一题
(A)select rand from posts;
(B)select rand(*) from posts;
(C)select rand(*) from posts LIMIT 1;
(D)select * from posts ORDER BY rand() LIMIT 1;