Ars Technica

SQL: an ORDER BY clause that will filter out "a" "an" and "the"

So I wanna sort something like "The Who" or "The Grateful Dead" by 'W' and 'G', respecively. How does one accomplish this? I tried using a function in the ORDER BY clause, but SQL syntax doesnt seem ...
Ars Technica

JPA result set paging - Order by needed?

I've seen numerous examples over the web that show how to page through a large result set returned by a JPA query. I'm wondering why this works. From what I understand, sql queries are NOT required to ...