How to calculate percentage with a SQL statement

by

  1. The most efficient (using over()).

    select Grade, count(*) * 100.0 / sum(count(*)) over()
from MyTable
group by Grade

  2. Universal (any SQL version).

    select Grade, count(*) * 100.0 / (select count(*) from MyTable)
from MyTable
group by Grade;

  3. With CTE, the least efficient.

    with t(Grade, GradeCount) 
as 
( 
    select Grade, count(*) 
    from MyTable
    group by Grade
)
select Grade, GradeCount * 100.0/(select sum(GradeCount) from t)
from t;

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Get top 1 row of each group
  3. How to calculate age (in years) based on Date of Birth and getDate()
  4. CROSS JOIN vs INNER JOIN in SQL
  5. Convert Month Number to Month Name Function in SQL
  6. SET versus SELECT when assigning variables?
  7. T-SQL dynamic pivot
  8. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  9. Generate Dates between date ranges
  10. Select group of rows that match all items in a list
  11. Add Foreign Key relationship between two Databases
  12. How to print VARCHAR(MAX) using Print Statement?
  13. How to assign an exec result to a sql variable?
  14. Concatenate values based on ID
  15. Query error with ambiguous column name in SQL
  16. Why (and how) to split column using master..spt_values?
  17. Splitting delimited values in a SQL column into multiple rows
  18. What does =* mean?
  19. SQL: parse the first, middle and last name from a fullname field
  20. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  21. SQL Select Upcoming Birthdays
  22. How can I include null values in a MIN or MAX?
  23. Stored procedure that exports data into csv files only exports to one file
  24. Get Start and End Date from Week Number SQL Server
  25. How to get the identity of an inserted row?
  26. Get the last day of the month in SQL
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. SQL take just the numeric values from a varchar
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment