Post reply

Comparing 2 rows in the same table for differences

  • February 11, 2016 at 3:48 am

    #311335

    Hi,

    Can you help me please? I need the ability to compare 2 rows in the same table for differences? Ideally - I would like the output to display just the fields that are different. I would really appreciate any help/assistance/code-samples that you may be able to supply.

    Thanks,

    J.

  • February 11, 2016 at 4:15 am

    #1857955

    Please provide us with some DDL (create table) commands and some sample data (insert). Also specify the desired output based on the provided sample data.

    You also need to specify the relation between the rows in the table. What are the rules that define which row must be compared with a specific other row? Does a single row need to compare to a single other row? Or does it need to be compared to all other rows in the table?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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

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