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