I know this is a simple quetsion but I am stuck. I need to create a view that displays the discount house price by 5%.

CREATE VIEW v_hou_discount AS SELECT hou_price - (hou_price * '.05') as '5% Discount Price' from house;

What am I doing wrong?

try using .05 in place of '.05'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.