从不同表中进行两次选择的 SQL 子查询给出随机选择

Question

从不同表中进行两次选择的 SQL 子查询给出随机选择

select top(1) Questions.Ques_ID, Question 
from Questions 
where   Questions.Ques_ID in(
                   select   top(4)  Answers.Que_ID,Answer 
                   from Answers 
                   where  Questions.Ques_ID = Answers.Que_ID   
                   order by newid())

Answer 1

使用 IN() 时，两侧应出现相同数量(和类型)的元素!

select top(1) Questions.Ques_ID, Question 
from Questions 
where   Questions.Ques_ID in(
                             select   top(4)  Answers.Que_ID 
                               from Answers 
                               where  Questions.Ques_ID = Answers.Que_ID   
                               order by newid())