SQL test

[DimPrawn]

name age salary
---------- ---------- ----------
dan 23 67
bob 45 94
tom 24 94
sue 23 45
joe 45 51
sam 22 51


Write SQL to find the youngest person earning the highest salary.

The answer is tom aged 24 by the way.

Anyone?

 

[Joe Black.]

1.30 before kick off? Anyway it might classify as work and I'm trying to go the whole day without doing any. So far so good and only 1 hour to go.

 

[threaded]

Do your own homework!

Bloody students. Mutter, mutter, mutter, grump, mutter.

 

[kramer]

thinking about the football and putting off writing a vision/scope document...(WHY?).....this is gonna be even more painful on a friday

 

[DimPrawn]

No one man enough for the task?

Typical contractors. I expect one the permies here eager to please will take up the challenge.....

 

[kramer]

select top 1 * from table order by salary desc, age asc

is that correct?

 

[Joe Black.]

I'm watching some removals men across the road.

It's hot & they're making me feel tired...

What kind of 'watching' are you doing. The kind where you touch yourself at the same time? Or are just interested in removalling (SIC).

 

[sasguru]

No one man enough for the task?

Typical contractors. I expect one the permies here eager to please will take up the challenge.....

I'm a manager, dear boy.... I'll set it as a task for one of my minions. I myself am occupied with higher matters, such as which pub to watch the footie in.

 

[DimPrawn]

That's good, but the SQL engine has to do two sorts on the data and a top 1 to throw all the other rows away.

Any other ideas?

 

[bennyboy]

I'm watching some removals men across the road.

Big gay green lizard