Frequency & amplitue

Question

I have a sql table which contains 2 columns:

How to calculate the frequency of the highest amplitude wave ? (Each wave is of fixed frequency). Thank you

Is the second column the amplitude? – Chris Lear Oct 05 '15 at 12:32 — Chris Lear, Oct 05 '15 at 12:32

score -1 · Accepted Answer · answered Oct 05 '15 at 13:02

-1

Try this

select 1/Time as frequency from <table> order by amplitude desc limit 1

answered Oct 05 '15 at 13:02

Chris Lear

1

This gives a number, which is almost certainly wrong. The time shown is periodic (1.64E-08 step) which means that the data represents a time series. – MSalters Dec 11 '15 at 16:06

1 Answers1