For example, I have a table named XYZ and it has a column COUNTRY, how can I take out results in the following format using group by function,
INDIA has 3 employees
here 3 is opted from count() and INDIA is grouped by "GROUP BY", my question is that how do you print ‘has’ and employees in between and at the end in mySQl
I am learning DBMS in Oracle APEX.
In MySQL / MariaDB you want
SELECT CONCAT_WS(' ', country, 'has', COUNT(*), 'employees')
In Oracle you want
SELECT country || ' has ' || COUNT(*) || ' employees
Edit This is plain old string processing. Every language, including every SQL dialect, has its own ways of doing string processing.
You can generate any sort of string you want, either with Oracle’s
|| or MariaDB / MySQL’s CONCAT_WS(). For your example, it’s
SELECT CONCAT_WS(' ', COUNT(*), 'employees from', country)
SELECT COUNT(*) || ' employees from ' || country
Answered By – O. Jones
Answer Checked By – Candace Johnson (BugsFixing Volunteer)