Question discussion

What does the following query return (two columns)?CREATE TABLE a(x INT); INSERT INTO a VALUES (1),(2),(2); CREATE TABLE b(x INT); INSERT I…

1562Medium DSSSB TGT Computer Science 0 replies 1 views
0

What does the following query return (two columns)?

CREATE TABLE a(x INT); INSERT INTO a VALUES (1),(2),(2);
CREATE TABLE b(x INT); INSERT INTO b VALUES (2),(3);
SELECT (SELECT COUNT(*) FROM (SELECT x FROM a UNION SELECT x FROM b) AS t1),
       (SELECT COUNT(*) FROM (SELECT x FROM a UNION ALL SELECT x FROM b) AS t2);
  • A3 3
  • B5 3
  • C5 5
  • D3 5
Correct answer: D

Explanation

UNION removes duplicates and leaves {1, 2, 3} (3 rows), while UNION ALL keeps every row (3 + 2 = 5).

Discussion 0

Nobody has replied yet. Start the discussion!