Denne browser understøttes ikke længere.
Opgrader til Microsoft Edge for at drage fordel af de nyeste funktioner, sikkerhedsopdateringer og teknisk support.
A query with a subquery in the WHERE clause returns the following error: Msg 512, Level 16, State 1, Line 17 Subquery returned more than 1 value. This isn't permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. What can we do to fix this error?
Make sure the subquery isn't using SELECT * in the SELECT list.
Change the operator introducing the subquery to IN or NOT IN
Add DISTINCT to the SELECT list
Which of the following statements is true of correlated subqueries?
A correlated subquery returns a single scalar value
A correlated subquery returns multiple columns and rows
A correlated subquery references a value in the outer query
You must answer all questions before checking your work.
Var denne side nyttig?