SQL - COMPARING MULTIPLE FIELD IN A TABLE

Question

I want to compare 3 fields value in a table. example:column 1 - 10 items column 2 - 7 items with 3 Null column 3 - 4 items with 6 null

anybody can help me!

               items          column1    column2       column3
                  1               BK1    NULL            BK1
                  2               RK1    RK1             RK1
                  3               SK1    SK2             NULL
                  4               AK1    AK1             AK2
                  5               CK1    CK2             CK2
                  6               DK1    NULL            NULL
                  7               EK1    EK1             NULL
                  8               FK1    NULL            NULL
                  9               GK1    GK1             NULL
                  10              HK1    NULL            NULL

Reuslt

                items            column1 column2       column3  RESULT
                  1               BK1    NULL            BK1    OK
                  2               RK1    RK1             RK1    OK
                  3               SK1    SK2             NULL   NOT EQUAL
                  4               AK1    AK1             AK2    NOT EQUAL
                  5               CK1    CK2             CK2    NOT EQUAL
                  6               DK1    NULL            NULL   OK
                  7               EK1    EK1             NULL   OK
                  8               FK1    NULL            NULL   OK
                  9               GK1    GK1             NULL   OK
                  10              HK1    NULL            NULL   OK

We can't figure out what you are asking for without any info... — jarlh
– jarlh, Commented Sep 11, 2015 at 9:43
Great. And what's the output you want, if you have the table data as above? — jarlh
– jarlh, Commented Sep 11, 2015 at 9:57

ram hemasri · Accepted Answer · 2015-09-11 10:14:59Z

1

I hope following can be helpful

select * from tablename            
where (column1 is not null and column2 is not NULL and column3 is not NULL)
and (column1 = column2 or column2 = column3 or column3 = column1 )

Please check SQLFiddle example http://sqlfiddle.com/#!3/fe38f/1

answered Sep 11, 2015 at 10:14

ram hemasri

1,63611 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Justina Felisita Over a year ago

It is omitting the null value items

Justina Felisita Over a year ago

I need query to compare the field with null value, Please see the Result in Item number 1

jarlh · Accepted Answer · 2015-09-11 11:40:57Z

0

select * from tablename
where
    (c1 is null or ((c2 is null or c1 = c2) and (c3 is null or c1 = c3)))
 and
    (c2 is null or ((c1 is null or c1 = c2) and (c3 is null or c2 = c3)))
 and
    (c3 is null or ((c1 is null or c1 = c3) and (c2 is null or c2 = c3)))

edited Sep 11, 2015 at 11:40

answered Sep 11, 2015 at 10:08

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

1 Comment

Justina Felisita Over a year ago

Need to add any extra bracket

Collectives™ on Stack Overflow

SQL - COMPARING MULTIPLE FIELD IN A TABLE

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related