How Many Records Will Be Retrieved by the Following Query
Question 19
Multiple Choice
How many records will be retrieved by the following query on table AGENT?
SELECT a.agentname,s.agentname
FROM agent a,agent s
WHERE a.supervisedby = s.agentid;
A)0
B)1
C)2
D)4