Examveda
Examveda

Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return

A. less than 10 rows

B. more than 10 rows

C. exactly 10 rows

D. None of these

Answer: Option C

Solution(By Examveda Team)

In SQL, the "SELECT ALL" statement is used to select all rows, which is the default behavior of the "SELECT" statement. If the statement "SELECT column1 FROM myTable;" returns 10 rows, then the statement "SELECT ALL column1 FROM myTable;" will also return exactly 10 rows because it selects all rows from the specified column in the table. Option C is the correct choice.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Related Questions on Sql Miscellaneous