Question

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 1

option b is correct

Answer 2

Answer:

The correct answer is more than 10 rows.

Explanation:

Given:

SELECT column1 FROM myTable;

return 10 rows. The statement

SELECT ALL column1 FROM myTable;

will return

From the above query we can conclude that, It will select only a particular column from 1st column that is having total of 10 rows. So, when we select only a particular column from the rows it will be beyond 10 rows. Therefore, it is true it will occur due to the number of rows selected.

#SPJ3