How can I use parameters in plain sql

How can I use parameters in plain sql like sql server.

FICTIONAL example that works for sql server:
declare @i int;
set @i = 1;
select * from mytable where id=(at)i;