[RESOLVED] return two rows using distinct?

[Davidc316]

Hi,

What I'm trying to do is really simple. However, in spite of two days of searching (Google, here, manuals and elsewhere) I can't find a solid answer. I'm very close to giving up and rethinking my life. Can anyone out there help me to get my life back?

Here's the situation:

I have a very simple table called store_item_size. The table has 3 columns (id, item_size, item_id). My goal is to search for rows with only distinct item sizes.

If I use 'select distinct item_size from store_item_size' then I do not get the column ID number (which I really need to know).

Does anyone know a way to return both the ID number and the item_size when that search for distinct sizes is executed?

Many thanks!

[Davidc316]

I've found the solution to my problem and I'll post it, just incase anyone else ever experiences the same problem.

The solution is not to use distinct. Instead you should use GROUP BY. For example:

SELECT id, item_size FROM store_item_size GROUP BY item_size

[zzz]

Which ID, the row or the item?

How about:

SELECT * FROM store_item_size
GROUP by item_size

Now, your questions seem to be incorrect. If indeed you need 2 rows, then you'll add
LIMIT 2.

SELECT * FROM store_item_size
GROUP by item_size
LIMIT 2

If what you meant two columns, then

SELECT  item_size, item_id FROM store_item_size
GROUP by item_size

[Davidc316]

It doesn't really matter. What you've written is spot on.

Thank you!