Skip to content

Instantly share code, notes, and snippets.

@rashivkp
Created November 28, 2013 16:24
Show Gist options
  • Save rashivkp/def089574ef9d0b9d47d to your computer and use it in GitHub Desktop.
Save rashivkp/def089574ef9d0b9d47d to your computer and use it in GitHub Desktop.
list of participants by appeal, who got ranks 1, 2, 3
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