TryCF Gist

trycf-gist-1693571025632-15c09b62-7056-a30f-0e63-57658ae44126.cfm

<cfset users = queryNew("id, firstname", "integer, varchar", [
{"id":1, "firstname":"Han"},
{"id":2, "firstname":"Han"},
{"id":3, "firstname":"James"}
])>

<cfset writeDump(users)>
<cfquery name="u1" dbtype="query">
    select firstname name from users
    group by name
</cfquery>
<cfset writeDump(u1)>
<cfquery name="u2" dbtype="query">
    select firstname name from users
    group by firstname
</cfquery>
<cfset writeDump(u2)>

<cftry>
    <cfquery name="u1" dbtype="query">
        select u1.firstname name 
        from    users u1, users u2
        where   u1.firstname=u2.firstname
        group by name
    </cfquery>
    <cfset writeDump(u1)>
    <cfcatch><cfoutput>#cfcatch#</cfoutput></cfcatch>
</cftry>
<cftry>

<cfquery name="u2" dbtype="query">
    select u1.firstname name 
    from    users u1, users u2
    where   u1.firstname=u2.firstname
    group by firstname
</cfquery>
<cfset writeDump(u2)>

<cfcatch><cfoutput>#cfcatch#</cfoutput></cfcatch>
</cftry>