hi,
i have a decimal(10,2) field. i want to sort my results accordin to the lowest decimal value. for example:
25.00
25.50
26.00
so i have this query:
SELECT
Price, PromotionalOffer, Website, Borough, MoreInfo, BusinessName
FROM
client_boroughs
JOIN
client ON client_boroughs.idClient=client.idClient
WHERE
Borough ='Southwark' order by (Price) ASC;
so i am using order by (price) ASC to do this and it works, but is this the right way of doing this? is there a scenario where this could fail? should i be using somesort of math function to do this?