Select max - Dev Shed

Dev Shed Forums Sponsor:

October 19th, 2012, 08:23 AM

ParisByNight

Registered User

Join Date: Oct 2012

Posts: 1

Time spent in forums: 1 h 35 m 39 sec
Reputation Power: 0

Select max

Hello all.

I have 2 tables,
- Users with userId, userName
- Affiliations with id, affiliationId, affiliationStartDate, affiliationEndDate

How to find in a select all guys that haven't renew their affiliation before a certain date ?
So I'm looking for userName and max(affiliationEndDate) where max(affiliationEndDate) < '2012-11-01' ?

I'm using MySql 3.23.58

Yhanks for your help

October 19th, 2012, 11:12 AM

Problem Solver

Join Date: Jan 2001

Location: Stockholm, Sweden

Posts: 4,434

Time spent in forums: 3 Weeks 4 Days 8 h 1 m 53 sec
Reputation Power: 532

Something like this (not verified):

Code:

SELECT
  u.userName
  ,max(a.affiliationEndDate)
FROM
  users u
INNER
  JOIN
    affiliations a
    ON u.userid = a.id
GROUP
  BY
    u.userName
HAVING
  max(a.affiliationEndDate) < '2012-11-01'

Quote:

Originally Posted by ParisByNight

I'm using MySql 3.23.58

Holy cr*p!
If you still use a software from 2003 I wonder how old your car is. Or if you work for NASA and have a really long procurement time.

__________________
/Stefan

Viewing: Dev Shed Forums > Databases > MySQL Help > Select max

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump