This discussion is archived
1 Reply Latest reply: Feb 7, 2013 10:30 PM by Marwim RSS

data change query

969918 Newbie
Currently Being Moderated
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

  • 1. Re: data change query
    Marwim Expert
    Currently Being Moderated
    Hello Rajesh,

    this is the forum for the tool SQL Developer. Your question should be placed at {forum:id=75}.

    Please mark this question (and the second posting) as answered and post again in the other forum.

    Best regards


  • Correct Answers - 10 points
  • Helpful Answers - 5 points