COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which one of the following keyword is used to find out the number of values in a column?
|
|
Total
|
|
|
Count
|
|
|
Sum
|
|
|
Add
|
Explanation:
Detailed explanation-1: -column function finds the number of unique values in a column. Specify COUNT.
Detailed explanation-2: -SELECT COUNT(ALL column name) FROM table name; The ALL keyword will count all values in the table including duplicates. You can omit this keyword because the COUNT function uses the ALL keyword as the default whether you write it or not.
Detailed explanation-3: -Answer: D. SUM function is used to get the addition of numeric values.
There is 1 question to complete.