Skip to content

Instantly share code, notes, and snippets.

@fabiancarlos

fabiancarlos/standard_deviation.sql

Created August 29, 2012 22:02
Show Gist options
  • Save fabiancarlos/3519484 to your computer and use it in GitHub Desktop.
Save fabiancarlos/3519484 to your computer and use it in GitHub Desktop.
Download ZIP
Desvío Padrão
Raw
standard_deviation.sql
SET @_mediaGlobal := (SELECT AVG(valor) FROM produto ORDER BY valor);
SET @dp := (SELECT (STDDEV(valor)/2) as dp FROM produto ORDER BY valor);
select (@_mediaGlobal - @dp) as min, (@_mediaGlobal + @dp) as max, @dp, @_mediaGlobal, AVG(valor) as mediaReal from produto where valor >= (@_mediaGlobal - @dp) and valor <= (@_mediaGlobal + @dp) order by valor;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment