Question discussion

How many rows does the following query return?CREATE TABLE r(a INT, b TEXT); INSERT INTO r VALUES (1,'x'),(2,'y'),(3,'x'); CREATE TABLE s(b…

951Medium DSSSB TGT Computer Science 0 replies 1 views
0

How many rows does the following query return?

CREATE TABLE r(a INT, b TEXT);
INSERT INTO r VALUES (1,'x'),(2,'y'),(3,'x');
CREATE TABLE s(b TEXT, c INT);
INSERT INTO s VALUES ('x',10),('x',20),('z',30);
SELECT COUNT(*) FROM r NATURAL JOIN s;
  • A2
  • B4
  • C6
  • D3
Correct answer: B

Explanation

Natural join matches on b; the two r-tuples with b = 'x' each pair with the two s-tuples with b = 'x', giving 2 × 2 = 4 rows.

Discussion 0

Nobody has replied yet. Start the discussion!