NVS PGT CS 2017 Part-B
|
Question 66
|
Based on table CLUB, which of the following SQL query will display earliest and latest DOJ under each TYPE?
|
SELECT MIN(DOJ), MAX(DOJ) FROM CLUB;
|
|
|
SELECT MIN(DOJ), MAX(DOJ) FROM CLUB GROUP BY TYPE;
|
|
|
SELECT MIN(DOJ), MAX(DOJ),TYPE FROM CLUB GROUP BY TYPE;
|
|
|
SELECT MIN(DOJ), MAX(DOJ), TYPE GROUP BY TYPE FROM CLUB;
|
Question 66 Explanation:
The GROUP BY statement group rows that have the same values into summary rows.
The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.
The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.
Correct Answer: B
Question 66 Explanation:
The GROUP BY statement group rows that have the same values into summary rows.
The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.
The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.