UGC-NET | UGC NET CS 2018 Dec – II | Question 26
Consider the following tables (relations) :
Primary keys in the tables are shown using Underline. Now, Consider the following query:
SELECT S.Name, Sum (P.Marks) FROM Students S, Performance P WHERE S.Roll-No = P.Roll-No GROUP BY S.Name
The number of rows returned by the above query is
Explanation: There are two groups by name : Ramesh and Mukesh. So, answer is 2.