Selecet Query:
Output:
select * from customer where city='chennai' or city='bangalore' or city='hyderabad';
Output:
CUS_NO CUS_NAME ADDRESS CITY STATE PINCODE BAL_DUE ------ ------------ ---------- ------- -------- ---------- --------- 004 Ajay x mohalla chennai tamilnadu 123224 20000 005 shiva xyz mohalla chennai tamilnadu 21124 30000 006 nimai new mohalla bangalore karnatak 123224 20000 007 jayesh k road bangalore karnatak 233224 30000 008 sayam my city bangalore karnatak 233224 30000