hello, can we give the same field name in group by and order by ?
Eg. select count(*) from table group by filedname1 orderby filedname1 desc; ===== kavi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]