Selecting TOP ranking through SQL in Unica

BargaviBargavi Registered User

I have a table with 2 sections; sub_ID and RANK.

All sub_ID are special and there are around 100k and have all been given a RANK between 1 - 38 in the RANK segment.

I am working in Unica or IBM Campaign where in a SELECT cell I have to enter crude SQL that exclusive returns 5000 supporters where it chooses in light of the RANK in inclination for 38 and less.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file