lundi 18 juillet 2016

How to get columns names that been updated

Suppose I have a table like this :

Table 1: 
    date    account name type status  open_account_date 
    31.12.14  1000    20   40    50      31.12.14
    2.1.15    1000    10   10    50      31.12.14 
    3.1.15    1000     5   15    50      31.12.14

and I want to build a summary table like this for the first quarter :

account numOfChanges    Changes 
1000        4         (name, type)  

The first row in table 1 indicats that that the account was opened and somebody enterd for the account some details but the others indicats changes but i want to know which fields has been changed. Is there any suggestion or an idea how to perform this?

Aucun commentaire:

Enregistrer un commentaire