Re: Group by

[Aram Karapetyan]

I'm sorry It's my mistake.

table

id | col1 | col2 | col3 | col4
---------------------------------
1 | a1 | b1 | s1 | sda | dsaf
2 | a1 | b2 | s2 | dsf | sdafas
3 | a1 | b3 | s3 | sdf | sdfsdf
4 | a2 | c1 | s4 | fdsdf | sdf
5 | a2 | c2 | s5 | sdf | sdf
6 | a2 | c3 | s5 | sdf | dsf
--------------------------------

SELECT * from table1
group by col1

after this query I'll have

1 | a1 | b1 | s1 | sda | dsaf
4 | a2 | c1 | s4 | fdsdf | sdf
because these lines first in group

I need to get "for example" last lines
3 | a1 | b3 | s3 | sdf | sdfsdf
6 | a2 | c3 | s5 | sdf | dsf

Thanks.