Self Join query to ID a pattern fo data Needed
Posted on 2009-04-01
I have a table that has three fields.
datetime to the second.
I need a query that will allow me to find a pattern where sequential acct_nbr's numbers have been accessed by the same theID based on datetime to the second. Listed below is an example of the data. It does not represent the pattern I am trying to find. While I can sort by acct_nbr,datetime, and theID I can not bring the required pattern to the forefront. There are 20 millions records in the table.
All help is greatly appreciated.
Data looks like
acct_nbr datetime theID
123911111 2007-12-28 23:01:54.000 206936
133333333 2007-12-28 22:19:15.000 969023
644444444 2007-12-28 23:00:28.000 999633
155555555 2007-12-29 08:10:40.000 590635