Question

Which of the following SELECT statements limit the number of columns that are returned in the query result?

Question options:

	SELECT * FROM Product GROUP BY ManufacturerID;
	SELECT * FROM Product;
	SELECT ProductID, ProductName FROM Product;

Answer 1

Following are the select statements limit the number of columns that are returned in the query result:

1)
SELECT * FROM Product
GROUP BY ManufacturerID;

-> This statement will arrange the identical values in different rows of Column ManufacturerID into a group.

2)
SELECT ProductID, ProductName FROM Product;

-> This statement limits the ProductID and ProductName only not other so there is a limitation.

Why not this one?

# SELECT * FROM Product - This statement does not limit the number of columns that are returned in the query result as * means all the columns will be selected to view the data.