Consider the following student relation.

Student relation has Rno, Name, Branch, and year attributes.

Rno Name Branch Year
101 A CSE 1
102 B CSE 2
103 C CSE 2
104 D IT 2
105 E IT 2
106 F ME 1

What is the output for the given query?

Query:

Select Branch, Count(*)

From student

Where Branch <> CSE

Group by Branch;

1

Branch   Count

IT               2

ME             1

2

Branch   Count

CSE            1

CSE            2

3

Branch 

IT             

ME            

4

Branch   

CSE       

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation