Syntax error in GROUP BY clause

[zeweb]

Come posso cambiare una SQL del tipo

strSQL="SELECT * from products where new=true AND tip_UK<>'RFID' AND online=true ORDER BY model ASC"

in una che mi raggruppi per tip_UK

strSQL="SELECT * from products where new=true AND tip_UK<>'RFID' AND online=true GROUP BY tip_UK ASC"

mi da errore:
Syntax error in GROUP BY clause.
/wireless/uk/news.asp, line 125

devo indicare i campi che recupero invece di * ?

<% 
Set objConn = Server.CreateObject("ADODB.Connection") 
set rs=server.CreateObject("ADODB.recordset")
objConn.Open strCon
strSQL="SELECT * from products where new=true AND tip_UK<>'RFID' AND online=true GROUP BY tip_UK ASC" 
rs.Open strSQL, objConn,3,3
	
recordsperpage=5
rs.pagesize=recordsperpage
Pages=request.querystring("pagina")
if (len (Pages)>0 and isnumeric(Pages)) then
Pages=clng(Pages)
else
Pages=1
end if
%>

Grazie