So is my suggestion correct?

But you wan the department as well, right? (If it has a top salary > 50k) So it'd be like

SELECT Max(test.salary) AS MaxOfsalary, dept
FROM salary_table
GROUP BY salary_table.dept
HAVING (((Max(salary_table.salary))>50000));

eta: You don't really need the HAVING here. It could just be:

SELECT Max(salary_table.salary) AS MaxOfsalary,
salary_table.dept
FROM salary_table
WHERE (((salary_table.salary)>50000))
GROUP BY salary_table.dept;

eta: I just now noticed one place where I had my test table name instead....

ita, your subselect

SELECT salary AS top_salary FROM salary_table GROUP BY department

wouldn't work, as [salary] needs to be part of an aggregate function (MAX, etc.) if you're using a GROUP BY.

I really overthought that one...

Thanks.

No prob. I was overthinking it too at first. It does get more complex if you need the employee number too....

This may be a stupid question, but how hard is it to set up a Wordpress installation on a site?

Aha! Dreamhost does it automatically. Never mind.

And on a similar but different note, is there a web design person out here who'd be interested in redesigning a site for me (or my mother's non-profit)? It should be a simple job, and I can pay through PayPal or check or cookies. If so, please e-mail me at my profile address.

Sorted!

Going back to the conversation we had about set-top boxes not too long ago, I'm now strongly considering buying an LG BD390.

It's a blu-ray player, but it also has built-in wireless and USB. It does Netflix and Youtube streaming, and can play just about any type of file from a USB stick, USB hard drive, or network-streamed any DLNA/UPnP compatible server (I'm not really sure what that means, actually, but I'm doing some research). Still, just being able to copy over a season of ahemmed/self-encoded files to a USB key and play away sounds pretty great to me.

Hulu support would, again, be the killer feature addition, but for now it looks like it might be the best set-top out there, and blu-ray is just icing on the cake.

Does it do region free DVD? I need that somehow, and I'd rather not have two devices.

It doesn't look good, ita. Can't find a code anywhere, anyway, though there are some "region-free" ones advertised on E-bay, so either somebody's scamming or there's a code out there somewhere...