Select Distinct Deptnamebr From Institutep Pwhat Does The Above #588
select distinct dept_name<br /> from institute;</p> <p>What does the above query do?
This multiple choice question (MCQ) is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Introduction to Relational Model and SQL - Basic Operations - Quiz No.1.
select distinct dept_name
from institute;
from institute;
What does the above query do?
It gives all the tuples having a distinct dept_name
It gives the dept_name attribute values of all tuples without repetition
It gives all the dept_name attribute of all the tuples
It gives all the tuples having a null value under the dept_name attribute