COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Here which of the following displays the unique values of the column?SELECT ____ dept____name FROM instructor;
|
All
|
|
From
|
|
Distinct
|
|
Name
|
Explanation:
Detailed explanation-1: -2. Here which of the following displays the unique values of the column? SELECT dept nameFROMinstructor; a) Allb) Fromc) Distinctd) NameView AnswerAnswer: cExplanation: Distinct keyword selects only the entries that are unique.
Detailed explanation-2: -ANSWER:-1) The correct option is :-c) Distinct Explanation:-Distinct keyword is used to select only those entries which…
Detailed explanation-3: -SELECT DISTINCT column name FROM table name; SELECT column name FROM table name GROUP BY column name;
There is 1 question to complete.