Which type of subquery returns a single value and can be used within expressions or conditions in SQL statements?

  • Correlated subquery
  • Derived subquery
  • Nested subquery
  • Scalar subquery
A scalar subquery in DB2 returns a single value and can be used within expressions or conditions in SQL statements. This makes scalar subqueries versatile and commonly used in various scenarios. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *