what is the error in following query if students table contains several..., PostgreSQL, Databases

Test
- Model Test
Index

Question:What is the error in the following query if the students table contains several records?
       select name from students where name =
     (select name from students order by name);

A = should be replaced by in operator 
B Order by clause in the subquery should be preceded with a group by clause 
C Order by clause in the subquery can be used only if the where and group by clauses have been applied 
D Group by clause should be applied to the outer query 
E An order by clause is not allowed in a subquery 
F There is no error

/85

+ AnswerA

+ Report

Descriptive on PostgreSQL Ebook

Total Preview: 961

Question:What is the error in the following query if the students table contains several records? select name from students where name = (select name from students order by name);

A = should be replaced by in operator

B Order by clause in the subquery should be preceded with a group by clause

C Order by clause in the subquery can be used only if the where and group by clauses have been applied

D Group by clause should be applied to the outer query

E An order by clause is not allowed in a subquery

F There is no error

A