Query of a Query functionality was introduced in ColdFusion 5 and it gives the developer the ability to re-query a returned recordset. While it does implement the core set of SQL SELECT commands the one bit of functionality I miss is MySQL's Limit function (I miss this in ANY relational database thats not MySQL as it makes paginiation a doddle).
Limit in MySQL works as such:
The above code will display the first 10 results from your your (table is 0 indexed)
Starting from the 5th record this will bring back rows 6, 7, 8, 9, and 10