retagged by
278 views
7 votes
7 votes
closed with the note: Get the Answer

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.

retagged by

Related questions

0 votes
0 votes
0 answers
1
Asutosh asked Jul 7, 2018
210 views
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...
0 votes
0 votes
0 answers
2
iarnav asked Dec 5, 2017
191 views
Kindly explain Check Constraint in SQL with a small example!
1 votes
1 votes
1 answer
3
Rishi yadav asked Oct 6, 2017
389 views
Plzz explain