Skip to content

SelectDistinct.io

A tech blog about data, warehousing and analytics.

Tag: Teradata

Teradata’s Secret SQL | Qualify Clause

August 17, 2016 / Matt / Leave a comment

Teradata’s Qualify clause which, at the time of writing this and probably for the foreseeable future, only exists in Teradata, and is spectacularly awesome! Also, so are Koalas. 

Teradata's Secret Clause | Koalafy By
Meme of a koala poking fun at Teradata’s Qualify By clause.

Continue reading →

Recent Posts

  • Plural Table Name(s)
  • SQL | Find Patterns In A Dataset
  • When To Use A CTE – And When Not To
  • ETL, DDL, & Self-Documenting Code Generator
  • It’s Performance Review Time!

Categories

  • Business Objects Data Services
  • DBMS
  • Dimensional Design
  • Interview Questions
  • Javascript
  • JSON
  • Python
  • Random Thoughts
  • Reporting
  • SAP
  • SQL Foo
  • SSRS
  • Window Functions

Archives

  • October 2020
  • July 2019
  • June 2019
  • May 2019
  • November 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • March 2018
  • February 2018
  • December 2017
  • October 2017
  • September 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
Delivery by Matt Komyanek