SQL test

[DimPrawn]

I wondered how long it would take for this thread to be hijacked.

 

[ladymuck]

SELECT MIN(Age), MAX(Salary)
FROM [crappy table]
GROUP BY Name


Damn, hoped to get iti edited before anyone read it!

 

[DimPrawn]

Never seen SQL like that Ladymuck

 

[TheMonkey]

Yeah you cant do aggregates unless you use COMPUTE.

Hint: do a self join (something that most people don't even know or understand)

 

[DimPrawn]

SELECT MIN(Age), MAX(Salary)
FROM [crappy table]
GROUP BY Name


Damn, hoped to get iti edited before anyone read it!

That still doesn't give a single row does it?

I don't know, where are all the clever contractors......?

 

[bennyboy]

That still doesn't give a single row does it?

I don't know, where are all the clever contractors......?

Getting paid to do it

 

[ladymuck]

I don't 'do' SQL so I'm just trying to remember what I did in an HND years ago. Doesn't mean I'm not clever, just not clever at SQL. At least I tried!!

 

[jambuie]

If using Oracle use the following:

select name,
age,
salary
from
(select name,
age,
salary,
max(salary) over (partition by age) max_sal_for_age,
min(age) over (partition by 'A') min_age
from table)
where salary = max_sal_for_age
and age = min_age

 

[TheMonkey]

Now can someone translate that to ANSI SQL.

 

[bernie]

sql test

sql test

Select name from table
Where age in(
Select min(age)
From table
Where
Salary in(
Select max(salary)
From table))