From: johnny depp (really!) [mailto:nick_reyntj...@hotmail.com] > > Hello, > > I'm investigating if i should uses sqlite from within java? > I need an embedded database, no fancy user management or > anything... I'm > only interested in speed. > Sqlite looks good for the job..So I went out and found the someone has > written a java sqlite wrapper. > Great! > But I ran into a problem: > > I need to group some rows, and if the values for a column are > all the same I > want to return that value, > else I want to return "not the same".. like so: > > For this table: > > col1, col2 > A "1" > A "2" > B "1" > B "1" > > And the query: select ..... group by col1; // can't write the > query because > I don't know it.. > > I would like the result to be: > col1 col2 > A "not the same" > B "1"
Can't you do some post-processing from within Java? Seems like an easy thing to do with some code. /Daniel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
