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.
When using the MySQL Interface to connect from QuickSight, some of the generated SQL uses MySQL's LAG function. Unfortunately, ClickHouse's lag is not used due to casing differences. We cannot modify ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback