PostgreSQL PGCES-02 Exam - Topic 9 Question 51 Discussion

Question

Select one statement which will cause a syntax error.

A) SELECT (SELECT item FROM sale WHERE id = 1);

C) SELECT * FROM item WHERE cid IN (SELECT cid FROM customer);

D) SELECT * FROM sale WHERE name IN (SELECT name FROM names);

E) SELECT * FROM sale WHERE cid = ANY (SELECT cid FROM customer);

Accepted Answer

B) SELECT * FROM (SELECT * FROM customer);

Contribute your Thoughts: