Select Query:
Output:
select * from customer where city = 'chennai' AND cus_name LIKE 's%';
Output:
CUS_NO CUS_NAME ADDRESS CITY STATE PINCODE DUE_BAL ------- --------- ------- ------- ----- ------ -------- 008 sayam my city banglore karnatak 233224 30000