Jump to content

Archived

This topic is now archived and is closed to further replies.

darthjones

Need help combining these two queries

Recommended Posts

I have a table called names with the following fields - id, last_name, first_name. I want to get the last 10 entries based on id and then arrange the results based on last_name. I can do both separately but I can't figure out how to do them at the same time. Can both be done in one query?

Basically, I want to combine the following -

[code]select id from names order by id desc limit 10;
select last_name, first_name from names order by last_name;[/code]

Share this post


Link to post
Share on other sites
Assuming that you have MySQL 4.1+, you can do this easily in a subquery:

[code]SELECT last_name, first_name FROM names WHERE id IN ( select id from names order by id desc limit 10 ) [/code]

Share this post


Link to post
Share on other sites
[code]SELECT last_name, first_name FROM names WHERE id IN ( select id from names order by id desc limit 10 ) ORDER BY last_name[/code]

Share this post


Link to post
Share on other sites
Oops... I forgot to add back the ORDER BY clause, which would be the whole point! My bad.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.