Ši naršyklė nebepalaikoma.
Atnaujinkite į „Microsoft Edge“, kad pasinaudotumėte naujausiomis funkcijomis, saugos naujinimais ir techniniu palaikymu.
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.
Ar šis puslapis buvo naudingas?
Reikia pagalbos šioje temoje?
Norite išbandyti funkciją „Ask Learn“, kad patikslintų arba paaiškintų šią temą?