Sajid Anwar Sajid Anwar - 6 months ago 19
SQL Question

How to count height score from a table

enter image description here

SELECT * FROM `result` Where R_TestID=16 AND R_IsCorrect='yes'.


Actually I want this Where clasue and also count more repeated R_UserID.
Bundle of Thanks

Answer
SELECT count(distinct(R_UserID)) FROM `result` Where R_TestID=16 AND R_IsCorrect='yes'.