Cheelo X
Reputation: 33
SQL CASE return Dataset
I just have a quick question. Can you receive a set of data in a case statement similar to:
CASE WHEN 1 = 1 THEN (SELECT name, age, gender FROM people) END
Upvotes: 1
Views: 80
Answers (1)
Gordon Linoff
Reputation: 1269883
No, you cannot do this with a case expression in a select statement.
A case expression is a scalar expression, so it can return only one value.
I should note that some databases support tuples. In those databases, the values could be combined into a single tuple.
Upvotes: 1
Related Questions
- Multiple columns return in CASE Statement SQL
- case statement in SQL, how to return multiple variables?
- Return multiple fields using case in select statement of sql server
- Return multiple data from Case statement condition
- SQL SERVER 2008 select statement with case
- Collapsing case statement returned data?
- SQL - Column value manipulation -return dataset
- SQL case statement and use returned value
- SQL case: Return case value
- SQL return multiple values from CASE statement