InfluxData Inc. is the developer of InfluxDB, an open-source platform designed to retrieve and store time series data for monitoring, analysis, metrics and more. Recently, the company announced the ...

I want to design a query to compute some returns for stock data and in searching the 'SQL Server Books Online' I find a very small and not so helpful at all help section on the lead and lag functions.

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...