Series: Subject:
Question: 52 of 234
Students SQL Query
these are the columns in the exam_report table
EXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCE
now i want to know how many student have passed at the end of the yr for each paper? and if they r failed i need to know there mark of the last appearance for each paper(ie)he might have appeared 5 times but still he may have failed and i want the mark of the 5 appearance
EXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCE
now i want to know how many student have passed at the end of the yr for each paper? and if they r failed i need to know there mark of the last appearance for each paper(ie)he might have appeared 5 times but still he may have failed and i want the mark of the 5 appearance
Asked by:
radha11 |
Member Since Jul-2008
| Asked on: Jul 16th, 2008
Related Answered Questions
Related Open Questions
User Panel
Categories
Interview Coaching
Connect
Ads
Interview Question
Latest Questions
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
