SELECT MAX(d), host_position FROM (SELECT host_position, COUNT(host_position) as d FROM sss_host GROUP BY host_position) as e;
am getting and ERROR: Attribute e.host_position must be GROUPed or used in an aggregate function.
Please to advice what could be the problem and how can I rewrite it to work thanks in advance.
Kind regards +-----------------------------------------------------+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED] +----------------------------------------------------+
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
