Group by

[Aram Karapetyan]

Hello all.
Merry christmas and happy new year to all.

At first I want to sorry for my english and mey be I dublicate question.

The question is that in case of groupping (group by some_column) lines mysqld return first lines from groups how can I get lines buy some critery.

table
===========
| id | col1 | col2 |
| 1 | a1 | b1 |
| 2 | a1 | b2 |
| 3 | a1 | b3 |
| 4 | a2 | c1 |
| 4 | a2 | c2 |
| 4 | a2 | c3 |
=========

SELECT * from table1
where col1 = 'some_value'
group by col2

This query will return lines with id 1 and 2.
I need to get last lines for each group.

Thank you.
Again sorry for english.