Thunderstone Support Forums

I wish to write a likep query with results ordered by something other than the rank. However I still need to have the rank returned. Therefore I would be writing a query something like:

select $$rank r, ID where TextValue likep 'foobar' order by ID;

Will this return exactly the same set of results with or without the "order by" clause? Will the "order by" clause affect the rankings?

It will return the same set of results, with the same ranks, regardless of the ORDER BY. The ORDER BY only affects the order of the results, and is applied after the query in this case.