Selecet Query:

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

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