DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
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: -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.
There is 1 question to complete.