Suppose you had a column called SampleNumber. And in this column, you might have...
1 1 1 2 2 2 2 3 3 4 4 4 5 5 5 5 etc. How would you write the SQL statement that would return the maximum number of a sample? For example, if within the SampleNumber column, the SampleNumber 17 had more records (say there are 23 SampleNumber = 17 in the table, more than any other), you wanted to return the value 23? If I use max(SampleNum), that will return only the highest value in the column rather than what I want, right? Is group_concat used here? Thank you. Rick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users