I am querying a table for a specific range of rows. If the query returns nothing, I want another range of rows to be selected. Either it returns >0 specific rows or it is to return a (default) specific 6.
Should I do this in my server side language or can I do it all in the query? I am wondering about case where...but wouldn't it check for a zero return for each row rather than for the whole query?