Hi, i have the query below which i need to modify to get the 10 highest percentage values of profit out of my table
...(val - cost) / val
im getting divide by zero errors when i try to add " /val"
to the query below
and im only getting the 10 latest entries by using "TOP 10"
How would i get the 10 highest profit percentage values?
SELECT TOP 10 product,val,cost,(val - cost) AS profit
ORDER BY val DESC