Compare differences in row counts after loading

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Contact kduke

Post by kduke »

The trick is to get max twice. The second max has to less than first max to get the next to last max. This is a lot easier using SQL Server or Oracle specific SQL. I tend to write SQL that works on any database.
Mamu Kim
Top
Post Reply

Return to “General”