"johnny depp (really!)" <nick_reyntj...@hotmail.com> wrote in message news:22057169.p...@talk.nabble.com > You probably meant: > > select col1, case when min(col2) = max(col2) then min(col2) else 'not > the same' end > from mytable group by col1;
It works for me as originally written. Do you get any errors? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users