Created
November 28, 2013 16:24
-
-
Save rashivkp/def089574ef9d0b9d47d to your computer and use it in GitHub Desktop.
list of participants by appeal, who got ranks 1, 2, 3
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT pid.participant_name, sm.school_name, pid.item_code, im.item_name, rm.rank | |
FROM result_master AS rm | |
JOIN participant_item_details AS pid ON pid.participant_id = rm.participant_id | |
JOIN school_master AS sm ON sm.school_code = pid.school_code | |
JOIN item_master as im on im.item_code = rm.item_code | |
WHERE rm.`spo_id` > 0 | |
AND rm.`rank` in (1, 2, 3) | |
order by rm.rank; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment