Choose the correct option regarding the following query:

mhmadesk

Save to bookmark

2022-07-13

478

Medium

Choose the correct option regarding the following query:

WITH max_marks (VALUE) AS
(SELECT MAX(marks)
FROM student)
SELECT studentID
FROM student,max_marks
WHERE student.marks = max_marks.value;

The query is syntactically wrong
The query gives the studentID of the student with the maximum marks
The query gives the maximum marks amongst all the students
The query gives all the studentID values except the student with the maximum marks

Database, MCQ Questions, Database MCQ-questions,

mhmadesk

2022-07-13

need an explanation for this answer? contact us directly to get an explanation for this answer

(b).The query gives the studentID of the student with the maximum marks

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)