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
Post a Comment