sql server - SQL: Creating temporary variables - Stack Overflow

I'm new to SQL so please consider this noob question. Also, its so ... With Totals as ( select *, price * quantity as [Total price], from grocery ) select * , case when ...

stackoverflow.com