Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hi i have a table 'forum' with
Yeaah i know but my hosting won't upgrade.. maybe i should run my own server... :) Thx, -
-
Hi i have a table 'forum' with
Hi i have a table 'forum' with id - topic - user - datum - comment What i want is a table with only the max date with the corresponding user grouped by the topics so i can set the last message was post on ... by ... i found the solution in SQL: SELECT topic, user, datum FROM forum t1 WHERE... -
help with TSQL QUERY
i'am using MySQL 3.23.49 i also tried to inclose with [] but it won't work (same error)- Ewoud
- Post #10
- Forum: Microsoft SQL Server: Programming
-
-
help with TSQL QUERY
thx again but there is still an error. (date = datum & table = forum) SELECT topic, user, datum FROM forum t1 WHERE datum = ( SELECT MAX( datum ) FROM forum WHERE topic = t1.topic ) You have an error in your SQL syntax near 'SELECT MAX( datum ) FROM forum WHERE topic =...- Ewoud
- Post #6
- Forum: Microsoft SQL Server: Programming
-
help with TSQL QUERY
Thanks, But i don't think i explain it that clear.. i have a table with id - topic - user - date - comment What i want is a table with only the max date with the corresponding user grouped by the topics so i can set the last message was post on ... by ... Hope tis will clear up a bit...- Ewoud
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Querry prob.
Hi, I'am searching for a few day to a spec. query can someone help me? table A: R1 R2 R3 a - 6 - z d - 2 - p a - 5 - y g - 8 - w d - 6 - w I need: R1 R2 R3 a - 6 - z d - 6 - w g - 8 - w I 've allready try this query Select R1,max(R2),R3 from a group by R1 R1 R2 R3 a - 6 - z d - 6 - p...
