InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
You Want To Group The Following Set Of Select Returns, What Can You Group On? |
|
Answer» MAX(sum_of_cost), min(sum_of_cost), count(item_no), item_no. The only COLUMN that can be grouped on is the "item_no" column, the REST have aggregate FUNCTIONS ASSOCIATED with them. Max(sum_of_cost), min(sum_of_cost), count(item_no), item_no. The only column that can be grouped on is the "item_no" column, the rest have aggregate functions associated with them. |
|