PDA

View Full Version : حرفه ای: معادل Linq اين عبارت sql چيست؟



davoodrm666_666
چهارشنبه 18 خرداد 1390, 09:49 صبح
SELECT Functional.Poll_QuestionBank.Title, Functional.Poll_QuestionOption.Title AS OptionTitle,
cast( COUNT(*) as real)
/(select count (*)
from Functional.Poll_Answer ttt
INNER JOIN Functional.Poll_Question t2 ON ttt.PollQuestionId = t2.Id
where t2.Id = Functional.Poll_Question.Id) * 100

FROM Functional.Poll_Answer
INNER JOIN Functional.Poll_Question ON Functional.Poll_Answer.PollQuestionId = Functional.Poll_Question.Id
INNER JOIN Functional.Poll_QuestionBank ON Functional.Poll_Question.QuestionBankId = Functional.Poll_QuestionBank.Id
AND Functional.Poll_Question.QuestionBankId = Functional.Poll_QuestionBank.Id
INNER JOIN Functional.Poll_QuestionOption ON Functional.Poll_Answer.QuestionOptionId = Functional.Poll_QuestionOption.Id
GROUP BY Functional.Poll_QuestionBank.Title, Functional.Poll_QuestionOption.Title, Functional.Poll_Question.Number,
Functional.Poll_Question .Id
ORDER BY Functional.Poll_Question.Number