Select Query:

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

Leave a Reply

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA