AGGREGATE FUNCTION IN SQL
star
star
star
star
star
Last updated about 5 years ago
10 questions
Note from the author:
SQL AGGREGATE FUNCTION TEST
1
Q-1 What is the meaning of “GROUP BY” clause in Mysql?
Q-1 What is the meaning of “GROUP BY” clause in Mysql?
1
Q-2 Which clause is similar to “HAVING” clause in Mysql?
Q-2 Which clause is similar to “HAVING” clause in Mysql?
1
Q-3 What is the meaning of “HAVING” clause in Mysql?
Q-3 What is the meaning of “HAVING” clause in Mysql?
1
Q-4 “COUNT” keyword belongs to which categories in Mysql?
Q-4 “COUNT” keyword belongs to which categories in Mysql?
1
Q-5 Which among the following belongs to an “aggregate function”?
Q-5 Which among the following belongs to an “aggregate function”?
1
Q-6 Which of the following belongs to an “aggregate function”?
Q-6 Which of the following belongs to an “aggregate function”?
1
q-7 Which clause is used with an “aggregate functions”?
q-7 Which clause is used with an “aggregate functions”?
1
Q-8 What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
Q-8 What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?
SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
1
Q-9 What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement? SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name HAVING COUNT (emp_id)>
Q-9 What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?
SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name HAVING COUNT (emp_id)>
1
Q-10 A Group By clause can use column aliasing.
Q-10 A Group By clause can use column aliasing.