Member Avatar for ana_1234

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?

Edited by ana_1234
  • 2 Contributors
  • 1 Reply
  • 120 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

try using .05 in place of '.05'

Be a part of the DaniWeb community

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