"johnny depp (really!)" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
