question

chinnasankar avatar image
chinnasankar 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.
subquery
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?
1 Like 1 ·
If this is an interview question, post the same sentences on Google and you will get tons of information.
1 Like 1 ·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
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)"
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

radie00 avatar image
radie00 answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.