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.
- Prepare
- SQL
- Aggregation
- The Blunder
- Discussions
The Blunder
The Blunder
+ 0 comments SQL :
SELECT CEIL(AVG(salary) - AVG(REPLACE(salary, '0', ''))) FROM EMPLOYEES;
+ 0 comments SELECT CEIL(AVG(Salary) - AVG( REPLACE(Salary, '0', '') )) FROM EMPLOYEES;
+ 0 comments SELECT CEIL(AVG(Salary) - AVG(REPLACE(Salary, '0', ''))) FROM EMPLOYEES;
+ 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.
+ 0 comments select CEILING((select avg(salary) from EMPLOYEES)-(select avg(REPLACE(salary, '0', '')) from EMPLOYEES)) EMPLOYEES;
Load more conversations
Sort 1368 Discussions, By:
Please Login in order to post a comment