SQL   SQL & Derived Tables


Topic Replies Created
View PDT (Persistent Derived Tables) details 2 July 9, 2018
Scheduling PDT on day of week at a specific time 3 May 29, 2018
Unknown parameter "indexes" in derived table definition 4 May 18, 2018
Datagroup on max id from the table and date of the view? 4 May 15, 2018
Flag Insert Update and delete source record in target using informatica 1 May 4, 2018
PDT Naming: Development vs Production 3 April 19, 2018
Uses of if dev 3 July 16, 2015
Error: Illegal mix of collations 7 July 8, 2015
Join derived table to itself 2 January 27, 2018
Grouping dimension with contains of another dimension 3 January 16, 2018
Cumulative Sum in MySQL 6 May 9, 2015
Partial PDT Persistence 4 December 15, 2017
Context Comments 9 November 7, 2017
Daily average - Custom measure 10 March 9, 2017
Using Table Value Functions as a derived table with Paramters 2 November 14, 2017
Help for Looker generated UDF approx percentile distinct disc 4 May 17, 2017
SQL Runner 6 November 17, 2017
Native Derived Table Count Values are Incorrect 1 November 2, 2017
[Retired] Calculating the difference between dates 16 March 31, 2015
Reusing cascading derived tables (with nested filters) in multiple views 9 January 27, 2017
JOIN 2017 - Deep Dive - To Use or Not Use PDT's 3 September 10, 2017
Oracle Index Scan When Converting Dates TO_TIMESTAMP 9 January 9, 2017
Conditional Calculations with LAG Functions 5 July 19, 2017
Querying Views or PDTs in SQL Runner 3 July 12, 2017
What kind of SQL can I write in SQL Runner? 1 June 12, 2015
Cascading Derived Tables with Nested Filters 6 November 7, 2016
Flexible funnel tool - using a filter to choose a dimension 2 April 11, 2017
Cascading Persistent Derived Tables 3 March 15, 2017
Setting mysql session variables 3 February 21, 2017
Accessing nth value in templated filtering 4 February 17, 2017