i have a decimal(10,2) field. i want to sort my results accordin to the lowest decimal value. for example:
so i have this query:
Price, PromotionalOffer, Website, Borough, MoreInfo, BusinessName
client ON client_boroughs.idClient=client.idClient
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?
I'd use ORDER BY price ASC without the () around price.
is there a scenario where this could fail?
should i be using somesort of math function to do this?