2 sets of sorted results from 1 query?

[Mark_P_W]

What I want to do is retrieve two sets of sorted results from one table without having to make 2 queries to that particular table.

I have a downloads table of which records the number of downloads (column: downloads) and the date the download was added (column: dateadded).

If I were to display the top 10 downloads from my table and the last 10 records, I would normally do this using two queries, one sorted by downloads, and the other sorted by the dateadded column.

My question is, is it possible to achieve this with one query instead of two?

I'd appreciate any help.

edit: [now solved]

[Sxooter]

Yes, if your database supports unions. Most do (postgresql, oracle, firebird, late model MySQL) some don't (old MySQL...)

You just take the two queries and put a union between them. Note that they'll need the same field types in the same order to work.