求助一条高级的sql语句

Question

各位大佬，新年好！求教一个sql语句
数据表 question 的结构 如图

http://i2.bvimg.com/512979/5f...

请问下 如何从该表中 随机查出两列 不包括主键id为1和3 的sql语句如何写呢，谢谢~
//突然上传不了图片了 就用贴图库代替下 ^_^

Answer 1

答案很多，是否都是真正的随机呢？一种检验方法是让question表只含id = 1,2,3,4四行，看查询是否总能返回2，4两行。

select * from question where id not in (1,3)
order by random()
limit 2

Answer 2

SELECT * FROM question WHERE id >= ((SELECT MAX(id) FROM question)-(SELECT MIN(id) FROM question)) * RAND() + (SELECT MIN(id) FROM question)  
AND id NOT IN (1,3) LIMIT 1

Answer 3

SELECT FROM question WHERE id >= ((SELECT MAX(id) FROM question)-(SELECT MIN(id) FROM question)) RAND() + (SELECT MIN(id) FROM question) and id not in(1,3) LIMIT 2

參照url:https://www.cnblogs.com/leezh...