• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Subqueries

Sometimes it may not be possible to retrieve the results that you need from a simple Select statement. At times, you might need to create a Select statement and compare the results to that of another statement. In that case, you would want to use subqueries. A subquery is a query that is nested inside another query. There are two types of subqueries that you can use:

  • The In Operator

  • The Embedded Select Statement


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint