Can somebody tell me how to insert price using decimal datatype. I do it in the following way but error comes...ERROR--Table Created Successfully but records are not inserted.....
create table products(vend_id int,prod_id varchar(7),prod_price numeric(2,2))
insert into products values(1001,'TNT1',04.78)
insert into products values(1001,'TNT1',14.78)
insert into products values(1002,'TNT2',15)
insert into products values(1002,'TNT2',5)
select * from products
select vend_id from products where prod_price <= 5
I want to select those vend_id where prod_price <=5