grouping muli values in single query ?
-
I have 10000 rows of schools database. i want to write query such that schools wise ,subject wise ,no_of_students scored < 35 marks. i want to use group by command how do i ???? please help me ************ S G KORE *******************
-
I have 10000 rows of schools database. i want to write query such that schools wise ,subject wise ,no_of_students scored < 35 marks. i want to use group by command how do i ???? please help me ************ S G KORE *******************
-
I have 10000 rows of schools database. i want to write query such that schools wise ,subject wise ,no_of_students scored < 35 marks. i want to use group by command how do i ???? please help me ************ S G KORE *******************
Cmon be generous, what have you got so far, give us something more that the bare question to work with.
Select School,Subject, count(*) from suitable tables where score < 35 group by School,SubjectSuitable tables will be the only challengeNever underestimate the power of human stupidity RAH
-
Cmon be generous, what have you got so far, give us something more that the bare question to work with.
Select School,Subject, count(*) from suitable tables where score < 35 group by School,SubjectSuitable tables will be the only challengeNever underestimate the power of human stupidity RAH
Thank you Mycroft Holmes. I tried this. but i am getting only one subject grouping data. i want is :- School name ,count(lan1 marks <35), count(Lan2 marks < 35),count(Lan3 marks <35) ......I want to know school wise No of students who have failed in all subjects. Please tell me ************ S G KORE *******************
-
Thank you Mycroft Holmes. I tried this. but i am getting only one subject grouping data. i want is :- School name ,count(lan1 marks <35), count(Lan2 marks < 35),count(Lan3 marks <35) ......I want to know school wise No of students who have failed in all subjects. Please tell me ************ S G KORE *******************
shiva.kore wrote:
lan1 marks
What does this represent in your ideas. Do you want a count of all students who scored < 35 in EVERY subject. This is quite a bit more complex and requires more knowledge of your data. Basically get a distinct list of all student/scores > 35 then get a list of all student/scores who are NOT IN the > 35 list.
Never underestimate the power of human stupidity RAH