You have a table like this

ID   Status    Details

1    Finished   sdfsdfxlk

2    Pending   sdfsdfsdfdfdsfdfdf

3    Finished   sdfsdlkjlkjlkjlkjlk

4.  Pending    sdfs;.l;;dfdff

 

To get a table like this:

Type                     percentage

Pending                  50

Finished                  50

 

Use this:

SELECT Status, COUNT(Status) * 100 / (SELECT COUNT(*) AS Expr1 FROM support) AS Percentage FROM support AS support_1 GROUP BY Status

 

About Lei

I am an IT specialist with over 10 year experience - years on Automation, on-Premise or Azure.

I am happy to develop however never want be a full time developer. Only do what I have to do. If it has to be PowerShell,HTML, PHP, CSS, C#, VBS or JS, front end or backend, so be it, doesn't matter!

Spent years with Windows, SCCM, SharePoint, SQL and Exchange servers. For last several years, I have been actively working under On Premise > Azure environment.

THERE IS NO WAY BACK!!!

Current Certificates:
    Microsoft® Certified-
  • -Enterprise Administrator
  • -Database Administrator
  • -SharePoint Administrator
  • -Administering and Deploying SCCM 2012
Red Hat Certified Technician
ITIL V3 Foundation - Practitioner

Working on Azure Certificates now and hopefully they can stop upgrading their questions one day! GIVE ME A BREAK!

Contact Lei

Name *
Email *
Comments *

Traffic since 10/08/2016

Today48
Yesterday83
This week672
This month1968
Total416328

Visitor Info

  • IP: 54.227.51.103
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

1
Online

2017-12-17

Login