May 12, 2025 at 1:22 pm
Hello - I have attached a Word document here with details about my issue.
I have shown an excerpt from the main table in the first section. There are 5 different records for the subscriber in question.
The second section shows how the MAX command restricts the output to 2 records. This output makes sense.
The third section shows how I have attempted to join the MAX data table from the second section back to the main data table. My code is ineffective because it is yields three records instead of one. How do I restructure the query to yield only one record - the one with the MAX value in it?
Thank you!
May 12, 2025 at 1:24 pm
Sorry
May 12, 2025 at 9:00 pm
just an FYI.
the best way to get help here is to post the SQL statements to recreate your problem in a code window inside you post. People will be super wary of going to external sites to get your data (or won't go at all), which means your question won't get answered.
I always look at if from the perspective of "An expert's time is really expensive, so if I give enough information to answer my question (create table script(s), insert script(s), an explanation of what I intended my code to do, an expected output) then I generally get an answer very quickly. If I don't, I get either no answer or a not very helpful answer.
Hope that helps you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy