This discussion is archived
6 Replies Latest reply: Feb 8, 2013 12:56 AM by Girish Sharma RSS

Pls help me!!! data separation

969918 Newbie
Currently Being Moderated
Posted: Feb 7, 2013 10:19 PM Edit Reply

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



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