Have a tbl simiar to the following
 col1 col2 col3 col4
  a    b    a
  a    b1   a2   x
  a    b13  a21   x
  b    1b    1a
  b    1b1  a21  v
  b    1b11  a21  v1
...
I'm trying to figure out how to do a query that triggers off of col3 'limit 1' for each group of col1
doing
select * from tblX where col3='a21' limit 1 
obviously doesn't work
however,
 select * from tblX where col3='a21' and col1='a' limit 1 
and
 select * from tblX where col3='a21' and col1='b' limit 1 
would ... but this being multiple operations..
Any pointers on creating a single query?
thanks obviously doesn't
 
    