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