Sql oracal creat table

 Create table client (clientno varchar2(5),name varchar2(10),address1 varchar2(20),address2 varchar2(10),city varchar2(15),pincode int,state varchar2(20),balancedue int);

Insert into client values('c0001','ajay','thomash street','pawai','mumbai',122004,'maharatra',1500);

Insert into client values ('c0002','ram','vigyan street','pukter','jaipur',122011,'rajesjthan',1600);

Insert into client values ('c0003','anil','dayal street','rohin','delhi',123022,'delhi',2000);

Insert into client values ('c0004','rashmi','gelf course','extension','gurgoan',122001,'haryana',4000);

Insert into client values ('c0005','ankit','auring street','shastrinagar','meerut',122051,'uterpardesh',4500);


**Where condition**

Select*from client where balancedue<2000;

Comments

Popular Posts