Register

#SQL-DBMS

304 views
1 votes
1 votes
Consider two queries

Q1- SELECT DISTINCT a from R WHERE b>0 ;

Q2- SELECT a from R WHERE b>0 GROUP BY a;

a)Both produce same answer

b)The answer of Q1 is always contained in the answer to Q2

c)The answer of Q2 is always contained in the answer to Q1

d)Both produce different answer
User Avatar

1 Answer

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

7 votes
7 votes
0 answers
1
junaid ahmad asked Jul 20, 2017
286 views
#SQL-DBMS
Q.consider following relation; supplier(sid,sname,rating)/sid is the p.k parts(pid,pname,color)/pid is the p.k catalog(sid,pid,cost)/sid,pid is the p.k Write SQL command for : retrieve sid supplied every red parts but not any green parts.
Q.consider following relation;supplier(sid,sname,rating)/sid is the p.kparts(pid,pname,color)/pid is the p.kcatalog(sid,pid,cost)/sid,pid is the p.kWrite SQL command for ...
User Avatar
0 votes
0 votes
0 answers
2
Asutosh asked Jul 7, 2018
221 views
#DBMS #SQL
For the relations: A(pid, cid) B(pid, pname, powner) C(cid, cname, cdesciption) How will the query be executed : SELECT pname, cname FROM A, B, C WHERE B.powner = $somevalue AND EXISTS(SELECT * FROM A WHERE A.cid = C.cid AND A.pid = B.pid)
For the relations:A(pid, cid)B(pid, pname, powner)C(cid, cname, cdesciption)How will the query be executed :SELECT pname, cname FROM A, B, CWHERE B.powner = $somevalueAND...
User Avatar
0 votes
0 votes
0 answers
3
iarnav asked Dec 5, 2017
197 views
#DBMS #SQL Define Check Constraint in SQL
Kindly explain Check Constraint in SQL with a small example!
Kindly explain Check Constraint in SQL with a small example!
User Avatar
1 votes
1 votes
1 answer
4
Rishi yadav asked Oct 6, 2017
409 views
#SQL #TestBook
Plzz explain
Plzz explain
User Avatar
Link Copied!