Skip to content

Instantly share code, notes, and snippets.

Miles Jordan milesjordan

Block or report user

Report or block milesjordan

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@milesjordan
milesjordan / Circular Average SQL
Last active Feb 20, 2019 — forked from hegge/avg_cyclic()
How to get the circular average of a dataset in different databases
View Circular Average SQL
These files show how to get the circular average (cyclic mean) of a dataset using SQL, for different databases.
For MySQL an example select statement is shown, and for Oracle and PostgreSQL the way to create a user aggregate function that computes the circular average is shown.
Props to Hegge for kicking this off: https://gist.github.com/hegge/476950
You can’t perform that action at this time.