Register

Recent questions tagged sql

39 votes
5 answers
157
GATE CSE 2019 | Question: 51
A relational database contains two tables Student and Performance as shown below: ... S, Performance P WHERE P.Marks >84 GROUP BY S.Student_name; The number of rows returned by the above SQL query is ________
A relational database contains two tables Student and Performance as shown below:$$\overset{\text{Table: student}}{\begin{array}{|l|l|} \hline \text{Roll_no} & \text{Stud...
User Avatar
0 votes
1 answer
158
#DBMS
What are the parameters or procedure to follow to find out minimum no. of tables for given ER Diagram type of questions?
What are the parameters or procedure to follow to find out minimum no. of tables for given ER Diagram type of questions?
User Avatar
0 votes
1 answer
161
made easy test series
User Avatar
1 votes
1 answer
162
Ace Test Series 2019: DBMS - SQL Output
User Avatar
3 votes
2 answers
163
Applied Course | Mock GATE | Test 1 | Question: 28
Consider the following Relation $\text{employee}$ ... many number of tuples will be output after executing the following query? SELECT DISTINCT(manager) FROM employee; $1$ $2$ $4$ $5$
Consider the following Relation $\text{employee}$:$$\begin{array}{|l|l|l|} \hline \text{eno} & \text{ename} & \text{manager} \\ \hline 1 & \text{satish} & \text{rajeev} \...
User Avatar
0 votes
0 answers
164
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
166
corelated subquery
i don’t know how to solve co-related sub query...i practice lots of problems but still i cant solve can anyone tell the method or approach to solve co-related sub query with example?
i don’t know how to solve co-related sub query...i practice lots of problems but still i cant solvecan anyone tell the method or approach to solve co-related sub query ...
User Avatar
0 votes
0 answers
168
self doubt
raj A B c 4 3 4 2 7 2 6 8 5 SELECT * FROM raj T1 WHERE EXISTS ( SELECT * FROM raj T2 WHERE T1.A > T2.A); Explain the output of this query. (written in oracel sql). output : Row 3 then Row1 ( (6,8,5), (4,3,4))
rajABc434272685SELECT * FROM raj T1 WHERE EXISTS ( SELECT * FROM raj T2 WHERE T1.A T2.A); Explain the output of this query. (written in oracel sql).output : Row 3 th...
User Avatar
1 votes
1 answer
169
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
1 answer
171
Gateforum Test Series: Databases - Sql
the table “Sales89” contains information about the address,zip,sale-date,price and inflamation-adjusted “real-price” of 222 sales of single family homes in calcutta during 1989.Here is the table schema
the table “Sales89” contains information about the address,zip,sale-date,price and inflamation-adjusted “real-price” of 222 sales of single family homes in calcut...
User Avatar
0 votes
0 answers
173
DBMS, Made easy practice book
Can primary keys be updated using sql update query? Is such a query accepted/rejected?
Can primary keys be updated using sql update query?Is such a query accepted/rejected?
User Avatar
0 votes
1 answer
176
sql doubt
please give an example to differentiate between self join , natural join and join operation.
please give an example to differentiate between self join , natural join and join operation.
User Avatar
0 votes
2 answers
178
Self doubt SQL
Select Rating From professor P2 Where 5>=(Select count (*) From professor P3 Where P2.Rating <= P3.Rating); Can someone please explain the query?
Select Rating From professor P2 Where 5>=(Select count (*) From professor P3 Where P2.Rating <= P3.Rating);Can someone please explain the query?
User Avatar
0 votes
1 answer
179
Assertions
what is assertions in SQL?
what is assertions in SQL?
User Avatar
0 votes
0 answers
180
ME Test Series
Is the given explanation and answer correct, how can a.street =b.street will ensure both employee and manager lives in same street?
Is the given explanation and answer correct, how can a.street =b.street will ensure both employee and manager lives in same street?
User Avatar
Page: