К
Size: a a a
К
L
К
NP
В
id_lesson;id_studentт.е.
1;16
1;15
1;19
2;66
2;94
3;42
4;97
4;6
SELECT id_lesson, count(id_student) FROM table WHERE id_lesson BETWEEN 535 AND 545;
получаю вывод в одну строку: id_lesson;count(id_student)а хочу получить
535;70
535;9и т.д.
536;2
537;8
...
DI
id_lesson;id_studentт.е.
1;16
1;15
1;19
2;66
2;94
3;42
4;97
4;6
SELECT id_lesson, count(id_student) FROM table WHERE id_lesson BETWEEN 535 AND 545;
получаю вывод в одну строку: id_lesson;count(id_student)а хочу получить
535;70
535;9и т.д.
536;2
537;8
...
AS
NP
AS
AS
В
L