-
jilani, That isn't exactly what burf wanted. The requirement is the user has a row after 14 Mar but only if that same user does not have another row before that date. In the example data, user 1 has 3 rows:
1 - 1-march-08
1 - 5-march-08
1 - 15-march-08
While one of the rows is > 14 Mar, since there are also rows in the table before 14 Mar, this would eliminate user 1 from being returned.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|