DAU and MAU on the same table: aka how to count distinct over moving 30 days windows
55710
Netezza not supporting sub query and similar... any workaround?
24120
Return a column per date in a range
143058
Counting unique records across 2 columns and computing a score based on boolean values
57465
Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
36855
Moving rows 'up and down' in a database (SQL query help)
157903
how to create a data file with a column of date from day1 to dayN?
45258
How to use Today and Me in Calculated column
60555
How to count occurrences of a column value efficiently in SQL?
138361
What's faster, SELECT DISTINCT or GROUP BY in MySQL?
93921
Select groups based on number of unique / distinct values
25114
MYSQL sum() for distinct rows
146879
GROUP BY WEEK with SQL
109477
SQL Dynamic DatePart when using DateDiff
85400
How to get the count of each distinct value in a column?
57539
Deduplicate Data Using Having with Subquery
141135
MySQL - maximum of sum over different months with ties over multiple years
149810
Is there an automatic modification time stamp type for Oracle columns?