Register

sql query

361 views

2 Answers

0 votes
0 votes
Query 1 having error  is just becozz in particular group how can cid have same grade which is 4 and and if it be present than it will return some output only if in that all cid's( same becoz group) and all grade =4. which is false

 

hence ans is B.
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
3
rayhanrjt asked Jan 6, 2023
771 views
SQL Query
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
User Avatar
2 votes
2 votes
1 answer
4
Subhrangsu asked Jun 18, 2022
447 views
Write SQL query
Write SQL query to show all employees hired on June 4,1984 (non-default format) emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
User Avatar
Link Copied!