variable usage in sql

Question

How to declare variables and use them in where clause

Answer 1

declare @variable_name <data type (eg. int, table, varchar)>, ... n
then assign and reassign as needed using assignment operators in SQL standard supported by the given engine implementor (ms sql, mysql, etc.)