1 Reply Latest reply on Feb 8, 2013 2:09 PM by riedelme

    data change query

      hi all... i have a query...

      i have the following detail with me....

      Numbers Key     abc column     date
      12345     Y     JVN     7/30/2010 20:45
      12345     N     YVM     4/30/2011 1:45
      12354     Y     JVN     6/18/2007 14:37
      12345     N     YVM     5/13/2008 16:28

      i have N no of records like this. I need to write a query to find when the key underwent any change (from Y to N and from N to Y).

      This is for a single Numbers column(eg:12345). I have several numbers like this.

      Can someone help me with a querry for this???

      Thanks in advance


      Edited by: Rajesh Chennai on Feb 7, 2013 10:20 PM