Post reply

help with creating table defining co relation

  • August 14, 2006 at 7:53 pm

    #103220

    I want to create a table which has co-relation among one column ID

    Say I have values in a column A, B, C, D, E, and F

    there is this relation between them

       A B C D E F

    A  - 3 4 5 2 7

    B    -

    C       -

    D         -

    E           -

    F             -

    This means co-relation between A, B is 3

    A,C is 4

    A, D is 5

    A, E is 2 and so on.

    So how would i create a table like this and I should be able to select

    the maximum or minimum correlation according to requeirement from a

    group of correlations.

    like from the above data minimum is A,E = 2

    and maximum is A, D = 5

    there will be other groups like B, C and C,E and C,D and E,F will also

    be there and will have a corelation between them.

    There will only be groups of 2 alphabets.

  • August 15, 2006 at 1:42 am

    #655008

    Create a table with three columns. First column is the "from group", second column is "to group" and the third column is the co-relation between the two groups. Keep the data normalized.

    Then just add data as needed and select with

    select[third column]
from[my table]
where[first column] = 'a' and [second column] = 'e'
        or [first column] = 'e' and [second column] = 'a'

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply