Create a stored procedure with input parameters, the input points parameters, execute the stored procedure, get score is greater than the scores of all the statistical results of the students information (including student id, name, score, course gate number)

CodePudding user response:

 create proc proc_GetGtAvgInfo 
@ avg int 
As 
The begin 
Select student id, name, avg (score), count (1) the as gate number from score 
Group by student id, name 
Having avg (mark) & gt; @ avg 
End 

CodePudding user response:

Thank you very much for crab crab crab crab