79537660

Date: 2025-03-27 02:02:32
Score: 1
Natty:
Report link

Unfortunately there's no way to really create temp tables or to set user-defined variables in this platform there is a way however where you could mimic this logic by let's say creating a faux CTE. How so? Easy...

With t1 as(
select 1+1) 
select 235 as threshold from t1

This could also be a subquery depending on where you want to go but this way you can join it you can cross join it and then filter on it but it gives you a couple of options as opposed to the non-existent ones

Reasons:
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Amir Semsarzadeh