MySQL- group by and foreign key
Authored by Pavani (CBSE)
Computers
12th Grade
Used 20+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which clause is used with an "aggregate" function?
GROUP BY
SELECT
WHERE
Both GROUP BY and WHERE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the meaning of "GROUP BY" clause?
Group data by column values
Group data by row values
Group data by column and row values
None of the mentioned
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
How to select number of employees - department wise from Emp table (EmpNo, DeptNo, EmpName)?
Select empno, count(*) from Emp Group By deptno;
Select deptno, count(*) from Emp Group By deptno;
Select empno, count(*) from Emp Order By deptno;
Select deptno, count(*) from Emp Order By deptno;
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Null values in GROUP BY fields are omitted.
True
False
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which statements are true about Group By?
Group By is used to group set of values based on one or more values
Group By is used when we use aggregate functions
Group by does not guarantee sorting the data in any order
All of above
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
How to select Maximum Salary of Employee from each Department in Emp table(empno, ename, deptno, sal)?
Select deptno, sal from Emp Group By deptno Order By Max(Sal);
Select deptno, sal from Emp Group By deptno having sal = max(sal);
Select deptno, max(sal) from Emp Group By deptno;
Select deptno, max(sal) from Emp Order By Max(Sal);
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following is correct to count the total salary dept wise where there are more than two employees in a dept from emp table (empno, ename, deptno, sal)
SELECT deptno, sum(sal) As totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) = 2
SELECT deptno, sum(sal) As totalsal FROM emp where COUNT(empno) = 2 GROUP BY deptno
SELECT deptno, sum(sal) As totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) > 2
SELECT deptno, sum(sal) As totalsal FROM emp where COUNT(empno) > 2 GROUP BY deptno
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
