Register

Search results for sql+query

0 votes
1 answer
3
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
1 answer
4
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
2 votes
1 answer
5
GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 25
Consider the following SQL query: SELECT * FROM Staff s, Branch b WHERE s.branchNo = b.branchNo AND (s.position = 'Manager' AND b.city = 'Bangalore'); Which of the following relational algebra query gives the ...
Consider the following SQL query:SELECT * FROM Staff s, Branch b WHERE s.branchNo = b.branchNo AND (s.position = 'Manager' AND b.city = 'Bangalore');Which of the followin...
User Avatar
1 votes
1 answer
6
Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
User Avatar
1 votes
3 answers
7
Raghuramkrishnan 3e Exercise 5.1 Question no-5 page no-175 SQL
Class(name, meets_at, room, fid) Faculty(fid, fname, deptid) Find the names of faculty members who teach in every room in which some class is taught
Class(name, meets_at, room, fid)Faculty(fid, fname, deptid)Find the names of faculty members who teach in every room in which some class is taught
User Avatar
1 votes
1 answer
8
made easy test series
User Avatar
0 votes
0 answers
10
MadeEasy Test Series: Databases - Sql
I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?
I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?
User Avatar
0 votes
1 answer
15
dbms sql
i don't know the actual answer for the question according to me answer should be A please confirm it
i don't know the actual answer for the questionaccording to me answer should be A please confirm it
User Avatar
0 votes
1 answer
16
SQL self doubt
In this question:- https://gateoverflow.in/8225/gate2015-1-27 I am not understanding how the query is returning 2 . I think DISTINCT must be there to give the correct answer. Can you give some logical explanation?
In this question:-https://gateoverflow.in/8225/gate2015-1-27I am not understanding how the query is returning 2 .I think DISTINCT must be there to give the correct answer...
User Avatar
0 votes
1 answer
18
sql query
User Avatar
0 votes
0 answers
19
SQL query with NOT IN connective.
a) 0 b) 1 c) 2 d) 3
a) 0 b) 1 c) 2 d) 3
User Avatar
0 votes
2 answers
20
SQL Query
User Avatar
Page: