Return multiple rows when using AVG

why this SQL query returns me only one result ?

select data_value-AVG(data_value) from data

While the expected result is multiple rows with the difference to the average for each data_value

Source: mysql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.