Return Min value for criteria

[awap87]

Hi,

I'm looking for some help with a custom column I'm looking at adding to my database please.

Let's say I have a query with that returns the following data:

John Doe (name), 30 (age)
John Doe (name), 34 (age)
Jane Smith (name), 31 (age)

Is there anyway to add a column on the end that will return the Min age for each name?

So, the desired output would be:

John Doe (name), 30 (age), 30 (Min age for this name)
John Doe (name), 34 (age), 30 (Min age for this name)
Jane Smith (name), 31 (age), 31 (min age for this name)

There may be other criteria this will be based on, but I'll keep it simple for now.

For this particular part, for one reason or another, grouping by name isn't an option.

Does anyone know any way to do this at all?



Many thanks!

[CJ_London]

something like

SELECT T.*, S.MinAge
FROM myTable T INNER JOIN (SELECT name, min(age) AS MinAgeFROM myTable GROUP BY Name) S ON T.name=S.Name
Order BY T.Name, T.Age