try this
SELECT group_name, employees, surveys, COUNT( surveys ) AS test1,
concat(round(( surveys/employees * 100 ),2),'%') AS percentage
FROM a_test
GROUP BY employees
More Related Contents:
- Correct MySQL Syntax for WEEK
- MySQL Data – Best way to implement paging?
- How can I find all the tables in MySQL with specific column names in them?
- ERROR 2006 (HY000): MySQL server has gone away
- MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
- Calculate Age in MySQL (InnoDb)
- Create table variable in MySQL
- Mysql – delete from multiple tables with one query [duplicate]
- Stored procedure that Automatically delete rows older than 7 days in MYSQL
- Does MySQL index foreign key columns automatically?
- MySQL – Make an existing Field Unique
- How can I simulate an array variable in MySQL?
- mysql2 gem compiled for wrong mysql client library
- MySQL LIMIT clause equivalent for SQL SERVER
- MySQL – length() vs char_length()
- How to get the next auto-increment id in mysql
- Importing a csv into mysql via command line
- MySQL dynamic-pivot
- Hyphens in column names in MySQL DB
- Deleting duplicate rows from a table
- Modeling Product Variants
- How do I find which transaction is causing a “Waiting for table metadata lock” state?
- MySQL LIKE query with underscore
- ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0
- Reserved word in column name – insert into MySQL [duplicate]
- Communications link failure , Spring Boot + MySql +Docker + Hibernate
- Comparing with NULL values
- CakePHP – get last query run
- Why is connecting to MySQL server so slow?
- How to search and replace all instances of a string within a database?