Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Filter
Profile
Wall
Recent activity
All questions
All answers
Exams Taken
All Blogs
Answers by Shamshuddin
0
votes
1
GATE CSE 2022 | Question: 46
Consider the relational database with the following four schemas and their respective instances. Student(sNo, sName, dNo) Dept(dNo, dName) Course(cNo, cName, dNo) Register(sNo, cNo) ... SELECT cNo FROM Register WHERE sNo = S.sNo) The number of rows returned by the above $\text{SQL}$ query is ____________.
Consider the relational database with the following four schemas and their respective instances.Student(sNo, sName, dNo) Dept(dNo, dName)Course(cNo, cName, dNo) Register(...
12.7k
views
answered
Sep 9, 2022
Databases
gatecse-2022
numerical-answers
databases
sql
2-marks
+
–
2
votes
2
GATE CSE 2004 | Question: 53
The employee information in a company is stored in the relation Employee (name, sex, salary, deptName) Consider the following SQL query Select deptName From Employee Where sex = M' Group by deptName Having avg(salary) > (select avg ( ... salary of employees in same the department the average salary of male employees is more than the average salary in the company
The employee information in a company is stored in the relationEmployee (name, sex, salary, deptName)Consider the following SQL querySelect deptName From Employee Where s...
11.3k
views
answered
Sep 8, 2022
Databases
gatecse-2004
databases
sql
normal
+
–
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register