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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ewoud
  • Content: Threads
  • Order by date
  1. Ewoud

    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...
    • Ewoud
    • Thread
    • Replies: 5
    • Forum: MySQL
  2. Ewoud

    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...

Part and Inventory Search

Back
Top