CLOUD COMPUTING
CLOUD MIGRATION
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following SQL command can be used to check the number of rows in the table busroute?
|
|
select row ____ count from busroute
|
|
|
select count(*) from busroute
|
|
|
select @@rowcount from busroute
|
|
|
select sys.db ____ stats ____ number ____ of ____ row from busroute
|
Explanation:
Detailed explanation-1: -COUNT(*) returns the number of rows in a specified table, and it preserves duplicate rows.
Detailed explanation-2: -To test whether a row exists in a MySQL table or not, use exists condition. The exists condition can be used with subquery. It returns true when row exists in the table, otherwise false is returned. True is represented in the form of 1 and false is represented as 0.
Detailed explanation-3: -1. Which of the following clause is used to limit the number of rows retrieved from a SELECT query? Answer: B. The WHERE clause is used to restrict the number of rows returned from a SELECT query.
There is 1 question to complete.