多选题Which three statements about subqueries are true? （）AA single row subquery can retrieve only one column and one row.BA single row subquery can retrieve only one row but many columns.CA multiple row subquery can retrieve multiple rows and multiple colum
题目
多选题
Which three statements about subqueries are true? （）
A
A single row subquery can retrieve only one column and one row.
B
A single row subquery can retrieve only one row but many columns.
C
A multiple row subquery can retrieve multiple rows and multiple columns.
D
A multiple row subquery can be compared using the > operator.
E
A single row subquery can use the IN operator.
F
A multiple row subquery can use the = operator.