basic sql group by with percentage
- by David in Dakota
I have an issue and NO it is not homework, it's just a programmer who has been away from SQL for a long time having to solve a problem.
I have the following table:
create table students(
studentid int identity(1,1),
[name] varchar(200),
[group] varchar(10),
grade numeric(9,2)
)
go
The group is something arbitrary, assume…