Where SQL query in HDB

1.login to Hana studio.

2.select the correct and require schema. 

3.open HDBSQL session then. 

4.select * from "<DB_SCHEMA>." <TABLE IN THE SCHEMA> where cityname = 'london' 

 Note: Here where query will be used as filter.