Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question No . 8 Select Max ( sal ) , deptid , deptname from dept groupby deptid, deptname what would be the output of the
Question No
Select Maxsaldeptid deptname
from dept
groupby deptid, deptname
what would be the output of the above query
It will display all departments from dept table
It will display all deptid and deptname along with employee details who is g
It will display all deptid and deptname along with highest salary
It will throw an error
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started