[Home] [Help]
View: JTF_TERR_WINNERS_V
View Text
SELECT JTDR.ABSOLUTE_RANK ABSOLUTE_RANK
, JTDR.TERR_ID TERR_ID
, JTDR.NUM_QUAL NUM_QUAL
, JTDR.TOP_LEVEL_TERR_ID TOP_LEVEL_TERR_ID
, JTDR.QUAL_TYPE_ID QUAL_TYPE_ID
, JTDR.SOURCE_ID SOURCE_ID
FROM JTF_TERR_DENORM_RULES JTDR
WHERE JTDR.RELATED_TERR_ID = JTDR.TERR_ID ORDER BY JTDR.ABSOLUTE_RANK DESC
Columns
Name |
ABSOLUTE_RANK |
TERR_ID |
NUM_QUAL |
TOP_LEVEL_TERR_ID |
QUAL_TYPE_ID |
SOURCE_ID |