mysql> select profile_id, min(date(created_on)), max(date(created_on)) from sig_dumps group by profile_id having min(date(created_on))!= max(date(created_on)) ;
+------------+-----------------------+-----------------------+
| profile_id | min(date(created_on)) | max(date(created_on)) |
+------------+-----------------------+-----------------------+
| 3 | 2012-02-07 | 2012-02-14 |
| 4 | 2012-02-07 | 2012-02-14 |
| 5 | 2012-02-07 | 2012-02-14 |
| 9 | 2012-02-07 | 2012-02-14 |
+------------+-----------------------+-----------------------+
4 rows in set (0.00 sec)
Subscribe to:
Post Comments (Atom)
-
Step 1, New a project rails new demo Step 2, Update Gemfile add paperclip, mysql2 gem, enable JavaScript runtime gem 'mysql2' ...
-
I used 7z to zip this file under Windows, try to unzip it under linux [ang@walker temp]$ gunzip 2011.sdf.zip gunzip: 2011.sdf.zip: unkno...
-
When trying to access transmission from web-browswer i got the message : 403: Forbidden Unauthorized IP Address. Either disable the IP ad...
No comments:
Post a Comment