Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khan12
Starting Member
1 Post |
 Posted - 2011-06-16 : 09:56:25
|
| i have student table (stid,stname,class,... )course table as (courseid,courname,)stu-course (stid,courseid,marks) i need query doing this coursename, Noof students in course, pass, fail physics 80 40 40 chemiostry 60 40 20 maths 100 90 10 total(240) total(170) total(70)muhammad rafiq lecturer computer science department GPGC Nowshera contact no 03339184504 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2011-06-16 : 09:59:54
|
| homework it is.http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
query for student table course table and std-cour