MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The COUNT() function returns the number of rows that matches a specified criteria.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The COUNT() function with the WHERE clause returns the number of rows that matches a specified criterion. The COUNT() function with the DISTINCT keyword shows the number of unique rows of a column. The COUNT() function in SQL ignores the NULL values and doesn’t count them.

Detailed explanation-2: -SQL COUNT() Function The COUNT() function returns the number of rows that matches a specified criteria.

Detailed explanation-3: -SQL COUNT() function counts the total number of rows present in the database.

Detailed explanation-4: -The COUNT (*) function returns the number of rows that satisfy the WHERE clause of a SELECT statement. The following example finds how many rows in the stock table have the value HRO in the manu code column: SELECT COUNT(*) FROM stock WHERE manu code = ‘HRO’;

Detailed explanation-5: -The SQL COUNT( ) function is used to return the number of rows in a table. It is used with the Select( ) statement.

There is 1 question to complete.
Previous
Next