database query
Posted: Thu Mar 18, 2004 4:59 am
Db is liket his
my table is this
id|testId|studentId|marks|startTime|endTime |status |result
-------------------------------------------------------------
1 1 96 5 1079600091 1079600108 Completed Passed
2 2 96 6 1079600158 1079600168 Completed Passed
3 1 96 1 1079600413 1079600421 Completed Failed
Pls tell me how to query that gets as result the totel no of testtaken Count(TestId)
and No of passes and no of failed ie FailCount and PassCount in 1 query can i use Group by
Plshelp
Thanx in Advance
my table is this
id|testId|studentId|marks|startTime|endTime |status |result
-------------------------------------------------------------
1 1 96 5 1079600091 1079600108 Completed Passed
2 2 96 6 1079600158 1079600168 Completed Passed
3 1 96 1 1079600413 1079600421 Completed Failed
Pls tell me how to query that gets as result the totel no of testtaken Count(TestId)
and No of passes and no of failed ie FailCount and PassCount in 1 query can i use Group by
Plshelp
Thanx in Advance