|
Die klassischen Dateitypen können ab Januar 2021 nicht mehr verwendet werden. Sie können Ihre klassischen Dateien übertragen oder eine PDF herunterladen. Weitere Informationen

Using subqueries in wdata

Beantwortet
Demo anfordern

Is it possible to use sub queries other than using the WITH clause and UNION? If so is there a special way to use sub queries?

0

Kommentare

3 Kommentare

Datum Stimmen
  • Benjamin Wagner

    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

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

    0
  • Mike Davis

    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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.