Skip to content

Instantly share code, notes, and snippets.

@roulupen
Created November 10, 2014 16:07
Show Gist options
  • Save roulupen/9f3264a9113e31a986ce to your computer and use it in GitHub Desktop.
Save roulupen/9f3264a9113e31a986ce to your computer and use it in GitHub Desktop.
Difference of COUNT(*) between Query of Query(QoQ) and normal SQL Query
<!---SQL Query to get Artists --->
<cfquery name="qryGetArtists" datasource="cfartgallery">
SELECT * FROM ARTISTS
</cfquery>
<cfdump var="#qryGetArtists#" label="SQL Query to get Artists"><br/>
<!--- COUNT(*) by SQL Query --->
<cfquery name="qryGetArtistCount" datasource="cfartgallery">
SELECT COUNT(*) AS ArtistCount FROM ARTISTS WHERE ARTISTID = 100000
</cfquery>
<cfdump var="#qryGetArtistCount#" label="Artist Count By SQL Query"><br/>
<!---COUNT(*) by Query of Query --->
<cfquery name="qryGetArtistCountFromQoQ" dbtype="query">
SELECT COUNT(*) AS ArtistCount FROM qryGetArtists WHERE ARTISTID = 100000
</cfquery>
<cfdump var="#qryGetArtistCountFromQoQ#" label="Artist Count By Query of Query">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment