David דודו Markovitz

David דודו Markovitz has asked 4 questions and find answers to 114 problems.

Stats

About

David דודו Markovitz questions

SQL Challenge/Puzzle: Given a stack trace - How to find the top element at each point in time?
SQL Challenge/Puzzle: How to merge nested ranges?
How to list tables in their dependency order (based on foreign keys)?

David דודו Markovitz answers

COUNT() OVER conditioned on the CURRENT ROW
SQL oracle add a value
Substract Days to a Date in HIVE APACHE
View "Table Schema" for View in Teradata without access to table?
How can I avoid having too many datapoints (10000) in a KQL query?
How to create a window of arbitrary size in Kusto?
Aggregate strings in group by and ordered in Hive and Presto
How to detect if Tabular variable is empty in KQL
Counting occurrences in Amazon Redshift strings
SQL Server 2008 VarChar(Max) returns only 8000 Characters. Why?