Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Stored Procedures

Run the stored procedure

Report a typo

We have the students table with id, name, subject, and result fields:

ID	Name	Subject	Result
1	J.White	Math	4.5
2	A.Greence	Computer Science	4.3
3	N.Bannister	Biology	3.8
4	S.Tanner	Math	4.1

A developer wrote a stored procedure named OrderByExamResult that selects all students ordered by exam results:

CREATE PROCEDURE OrderByExamResult ()
BEGIN
    SELECT
        *
    FROM
        students
    ORDER BY
        result;
END;

What command should they use to execute this procedure?

Select one option from the list

PROCEDURE OrderByExamResult;

CALL OrderByExamResult;

SELECT OrderByExamResult;

RUN OrderByExamResult;

___

Create a free account to access the full topic