i have an error which i dont understand. can you help me? [closed]

by

Sub queries used for the IN clause can’t return multiple columns, so you can’t have SELECT reportsTo, COUNT( * ) AS count inside it. You probably want to join the subquery instead, something like this:

SELECT firstName,lastName,temp.count
FROM employees
INNER JOIN (
    SELECT reportsTo, COUNT( * ) AS count
    FROM employees
    GROUP BY reportsTo
) temp ON employees.employeeNumber = temp.reportsTo

Disclaimer: I don’t use MySQL so the above syntax may not be exact.

You’ll likely also run into issues trying to use count as a column name. Either rename it or escape it (SQL Server uses [ and ], not sure about MySQL).

More Related Contents:

  1. If two columns are 1 then make new column
  2. MySQL : isn’t in GROUP BY
  3. MySQL: Can’t create table (errno: 150)
  4. Restore table structure from frm and ibd files
  5. Subqueries with EXISTS vs IN – MySQL
  6. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  7. Composite key as foreign key (sql)
  8. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  9. mySQL query to search all tables within a database for a string?
  10. Which DB technology is sued to solve the following search issue? [closed]
  11. What is better subquery vs literal on IN clause in mysql
  12. When to use single quotes, double quotes, and backticks in MySQL
  13. How to return rows that have the same column values in MySql
  14. How to join two tables mysql?
  15. Multiple Updates in MySQL
  16. SQL split comma separated row [duplicate]
  17. Storing JSON in database vs. having a new column for each key
  18. MySQL – Subtracting value from previous row, group by
  19. How do I restore a dump file from mysqldump?
  20. MySQL – Conditional Foreign Key Constraints
  21. How to count items in comma separated list MySQL
  22. Groupwise maximum
  23. Error Code: 1406. Data too long for column – MySQL
  24. MySQL order by “best match”
  25. Is there a simple way to convert MySQL data into Title Case?
  26. Does mysql have the equivalent of Oracle’s “analytic functions”?
  27. Insert/ Update random date in MySQL
  28. Replace null with 0 in MySQL
  29. Get total hours worked in a day mysql
  30. ORDER BY alphabet first then follow by number

Leave a Comment