• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

SQL test

:uofftopic

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

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


Damn, hoped to get iti edited before anyone read it!
:rolleyes:
 
Last edited: 16:02
Never seen SQL like that Ladymuck :rolleyes:
 
Yeah you cant do aggregates unless you use COMPUTE.

Hint: do a self join (something that most people don't even know or understand)
 
ladymuck said:
SELECT MIN(Age), MAX(Salary)
FROM [crappy table]
GROUP BY Name


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

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

I don't know, where are all the clever contractors......?
 
DimPrawn said:
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 :D
 
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!!

;)
 
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
 
Now can someone translate that to ANSI SQL.
 
sql test

sql test

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

Advertisers

Back
Top