Ta brskalnik ni več podprt.
Izvedite nadgradnjo na Microsoft Edge, če želite izkoristiti vse prednosti najnovejših funkcij, varnostnih posodobitev in tehnične podpore.
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.
Ali je bila ta stran uporabna?
Ali potrebujete pomoč za to temo?
Ali želite preskusiti storitev Ask Learn, ki pojasni ali vas vodi skozi to temo?