Differences

This shows you the differences between two versions of the page.

teradata-to-oracle [July 02, 2016 2:31 pm]
sqlines
teradata-to-oracle [July 04, 2016 12:29 pm] (current)
sqlines
Line 84: Line 84:
| 1 | SEL keyword || Converted to SELECT | | 1 | SEL keyword || Converted to SELECT |
| 2 | SELECT without FROM clause || SELECT ... FROM //dual// | | 2 | SELECT without FROM clause || SELECT ... FROM //dual// |
 +
 +QUALIFY clause conversion:
 +
 +| **Teradata** | **Oracle** |
 +| SELECT c1 \\ FROM t1 \\ WHERE c1='A' \\ QUALIFY \\ ROW_NUMBER() OVER \\ (PARTITION by c1 ORDER BY c1) = 1 | SELECT * FROM \\ (SELECT c1, \\ ROW_NUMBER() OVER (PARTITION by c1 ORDER BY c1) rn \\ FROM t1 \\ WHERE c1='A' \\ ) WHERE rn = 1 |
 +
 +