> > >

MySQL MCQs

Which of the following queries is valid?

Select * from students where marks > avg(marks);

Select * from students order by marks where subject = 'SQL';

Select * from students having subject ='SQL';

Select name from students group by subject, name;

Select group(*) from students;

Select name,avg(marks) from students;

None of the above

Answer

Correct Answer: Select name from students group by subject, name;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it