consider the following relation.

Student(Rno, name, Branch, Year)

Rno name Branch Year
1 Balaji CSE 1
2 Ravi CSE 2
3 Vijay CSE 2
4 Sam IT 2
5 Suman IT 2
6 Ritu ME 1

What is the output for the given query?

Query:

Select branch, count(*) 

from student

group by branch ;

1

Branch    count(*)

CSE              2

IT                  2

ME                1

2

Branch    count(*)

CSE              3

IT                  2

ME                1

3

Branch    count(*)

CSE              2

IT                  2

ME                2

4

Branch    count(*)

CSE              3

IT                  3

ME                3

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation