1.

A relational database contains two tables Student and Performance as shown below:The primary key of the Student table is Roll_no. For the Performance table, the columns Roll_no. and Subject_code together from the primary key. Consider the SQL query given below:SELECT S.Student_name, sum(P.Marks)FROM Student S, Performance PWHERE P.Marks > 84GROUP BY S.Student_name;The number of rows returned by the above SQL query is _________ .Note: This was Numerical Type question.(A) 5(B) 4(C) 3(D) None of these.

Answer»


Discussion

No Comment Found

Related InterviewSolutions