asked
1.How to create subquery within subquery. 2.How to return more than one value in subquery.
1.How to create subquery within subquery. 2.How to return more than one value in subquery.
What is it that you are trying to achieve? What's the actual problem here? What have you tried so far? What's not working?
If this is an interview question, post the same sentences on Google and you will get tons of information.
1: select {columns} from ( select {columns} from ( select {columns from {table} where {where} ) ) A subquery can return multiple rows, depending on the where clause. If you would like to match against multiple values, use "WHERE {criteria} IN (subquery)"
Concerning your question :
http://stackoverflow.com/questions/1593531/a-subquery-within-a-subquery-is-it-possible
23 People are following this question.
