• 

  Benjamin Wagner

  • 2024年02月02日 21:24

  Hey Van McGregor

  Apologies for the delayed response! I reached out to our internal team because this was outside the scope of my expertise. It sounds like you were able to connect with our support team and they referred you to Presto SQL documentation. Hope their input was helpful!

  Thanks,

  Ben

  0
• 

  Katherine Korol

  • 2025年02月05日 15:26

  Van McGregor @... Also looking for the answer to this

  0
• 

  Mike Davis

  • 2025年02月05日 15:49

  Hi Katherine!

  Thanks for the follow-up here. I have somewhat of an answer here.

  It is possible to use subqueries in SQL without relying solely on the WITH clause or UNION. Alternative methods include:

  1. Nesting: Use a subquery within the SELECT statement, WHERE clause, or FROM clause. This method allows for one level of nesting, where one query depends on the result of another (more info here: https://support.workiva.com/hc/en-us/articles/21592422886420-Can-I-use-a-query-as-a-source-for-another-query)

  2. Quantifiers for Comparison: Use subqueries with comparison operators and quantifiers such as ALL, ANY, and SOME to filter results based on specific conditions (more info here: https://support.workiva.com/hc/en-us/articles/360052323491-SQL-comparison-functions-and-operators)

  These approaches allow flexibility in how subqueries are structured within SQL statements. Let me know if you have any additional questions. Cheers!

  0

请先登录再写评论。