Is there a away to calculate the percentage via a sql statment for the following
i have for example 100 Laptops and these laptops are being sold by several vendors i want to know the percentage of each vendor for example
vendor 1 sold 15
vendor 2 sold 35
vendor 3 sold 50
i want to know the percentage of each using the select sql..
Thanks to all.