KoloID FIRST SECOND THIRD FORTH
01 4 8 6 10
02 10 8 12 9
03 4 5 6 9
04 3 6 6 9 ETC
How can I use select to return P,P1, P2,... P10 ETC
P = relationship between values of the last koloId(04)
and koloID(3) = Number of cell with the sam values = 2
(6 and 9)
P1 = relationship between values of the last koloId(04)
and koloID(2) = Number of cell with the sam values = 1
P2 = relationship between values of the last koloId(04)
and koloID(1) = Number of cell with the sam values = 1
The database is being updated every week
The return should be in this form
KoloID P P1 P2 P3
01 - - - -
02 1 - - -
03 1 2 - -
04 2 1 1 -
IF FOR THE NEXT WEEK UPDATE VALUES ARE(05 4, 6, 7, 9)
THE RETURN SHOULD BE
05 2 2 1 1
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: