Archives of the TeradataForum
Message Posted: Thu, 02 Dec 2004 @ 21:32:49 GMT
<-- Anonymously Posted: Thursday, December 02, 2004 16:19 -->
If the table T1 has the following records:
Column Name Number of records Country 10 States 50 County 500
And heirarchy is something like this.
Many country can have many states and many counties
What is the best way to retrieve sample 50 County for each Country.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|