How to pass any parameter to this query? or add parameter in this query?

i am using one table called sales by this query I want to show all entire table but I am not getting how to use parameter in this 

SELECT a.City, b . * FROM sales a LEFT JOIN sales b ON a.City = b.City

or

SELECT * FROM sales WHERE City = ANY(
SELECT DISTINCT City FROM sales);