Taking the question _very_ literal: > A quick guess, or at least a starting point: > > SELECT key, data
, SUBSTRING_INDEX(GROUP_CONCAT(data ORDER BY data SEPARATOR ','),',',2) > FROM myTable > GROUP BY key <remove limit here> -- Rik Wasmus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql