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

[tejaswini.patil2000]

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);

[yassinswag50]

just look in the documentation.there is a lot of examples on how to fo that

[yama818]

If you want to know the basic way to use parameters in Studio's SQL, the following wiki may help you understand.
https://community.jaspersoft.com/wiki/using-report-parameters-jaspersoft-studio

 

You will need to see the manual for more detailed information.
https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/using-parameters-queries

 

I hope this is helpful.