Creating A Table Of Variables In SQL
Summary: The discussion was initiated by intapiuser, who expressed interest in creating a table of variables in SQL but did not provide further details or context.
MySQL aficionados have likely leveraged its ability to declare variables. Unfortunately, this capability isn't supported by all flavors of SQL. For such situations, we can still achieve a similar result by creating a CTE of variables (for more information on CTEs - refer to the post here!)
Example:
with
variables as (
select
2 as v1
, 'data' as v2
, ['2018-07-01':date] as v3
)
select
*
from
purchases
join variables on
1 = 1Notice how we have our variables readily accessible for each record. Now, feel free to calculate and plug in as needed!
Tip: Depending on your exact use case, you may opt to use a Parameterized SQL Snippet instead!
0 comments
