divide the value of a column by another column

sql sql-function
Sheik Syed Mohaideen picture Sheik Syed Mohaideen · Nov 24, 2011 · Viewed 59.1k times · Source

I want to divide a value of a column by the value of another column and display the result as separate column

ex:

project name             total-percent        no.of screen
------------            --------------        -------------
pro-1                     150                     5
pro-2                      50                     3

now i want to divide total-percent by no.of screen and display the result in another column

Answer

Mahmoud Gamal picture Mahmoud Gamal · Nov 24, 2011 
Select total_percent / no_of_scren as 'result' From yourTableName

Related questions

Function vs. Stored Procedure in SQL Server

I've been learning Functions and Stored Procedure for quite a while but I don't know why and when I should use a function or a stored procedure. They look same to me, maybe because I am kinda newbie about that. …

Read More
How to Replace Multiple Characters in SQL?

This is based on a similar question How to Replace Multiple Characters in Access SQL? I wrote this since sql server 2005 seems to have a limit on replace() function to 19 replacements inside a where clause. I have the following task: …

Read More
SQL Query - Concatenating Results into One String

I have a sql function that includes this code: DECLARE @CodeNameString varchar(100) SELECT CodeName FROM AccountCodes ORDER BY Sort I need to concatenate all results from the select query into CodeNameString. Obviously a FOREACH loop in C# code would do …

Read More