multiplying columns
-
actually i have five columns like system,name,qty,weight,area I have to fetch the details from database. I have to write a query where i have to multiply qty and weight and put it in weight column and at the same time i have to display the records in the descending order of total weight . How can this be done. Please help
skd
-
actually i have five columns like system,name,qty,weight,area I have to fetch the details from database. I have to write a query where i have to multiply qty and weight and put it in weight column and at the same time i have to display the records in the descending order of total weight . How can this be done. Please help
skd
It's a home work question, how about this
SELECT
[system]
,[name]
,[qty] * [weight] As TotalWeight
FROM
[dbo].[TestTable]
ORDER BY
TotalWeight DESCAll C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions