Store SQL query in a variable and resuse it

3/8/2016 - 11:23 PM

with supp as ( 
Select 			
			Fieldname            
      From Table
	  WHERE 
	  Something
	  )

SELECT * from supp where FieldName = 1

Cacher is the code snippet organizer for pro developers