TryCF Gist

trycf-gist-1641331465786-99162b47-44e6-b998-84df-4c116ceb6453.cfm

<cfscript>
employees = queryNew( 'name,age,email', 'varchar,integer,varchar',
            [
                [ 'John Doe',28,'John@company.com' ],
				[ 'Jane Doe',22,'Jane@company.com' ],
				[ 'Bane Doe',28,'Bane@company.com' ]
			] );

actual = QueryExecute(
		sql = "SELECT DISTINCT name, age, name from employees order by name, age",
		options = { dbtype: 'query' }
	);

dump( actual )
</cfscript>