We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. The Blunder
  5. Discussions

The Blunder

Sort 1368 Discussions, By:

  • youness_ahasla
     + 0 comments

    SQL :

    SELECT CEIL(AVG(salary) - AVG(REPLACE(salary, '0', ''))) FROM EMPLOYEES;

  • namnmfx22541
     + 0 comments
    SELECT CEIL(AVG(Salary) 
											- AVG(
											REPLACE(Salary, '0', '')
											))
FROM EMPLOYEES;

  • namnmfx22541
     + 0 comments
    SELECT CEIL(AVG(Salary) - AVG(REPLACE(Salary, '0', '')))
FROM EMPLOYEES;

  • mariana_soares
     + 3 comments

    If anyone could do this in MS SQL SERVER, please, leave here the answer, 'cause i couldn't. Always appears a VARCHAR error and I've tried all ways possible.

  • tejasgawade7744
     + 0 comments

    select CEILING((select avg(salary) from EMPLOYEES)-(select avg(REPLACE(salary, '0', '')) from EMPLOYEES)) EMPLOYEES;

Load more conversations