Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Dec 12, 08:55
2: Dec 11, 23:59
3: Dec 11, 14:43
4: Dec 11, 11:29
5: Dec 11, 07:59
6: Dec 10, 18:15
7: Dec 10, 12:28
8: Dec 10, 09:30
9: Dec 10, 05:59
10: Dec 9, 17:07
11: Dec 9, 13:47
12: Dec 9, 10:33
13: Dec 9, 07:33
14: Dec 8, 17:50
15: Dec 8, 10:32
16: Dec 8, 06:23
17: Dec 7, 16:52
18: Dec 7, 07:17
19: Dec 6, 14:40
20: Dec 6, 10:07
Posts: 152
In response to
"
doing that sort of meta-query in Postgres and MySQL is a bit painful ... but the first part can be easy
"
by
Beryllium
You will want to include the datatime variable in that subquery, then select the max(datetime) for each id from the subquery.
Posted by
GregW (aka not2fast)
Jun 11 '12, 14:13
I know how to do this in DB2, but not MSSQL.
Responses:
thanks -- nm
-
zork
Jun 11, 14:26
Post a message
top
Replies are disabled on threads older than 7 days.