I have a simple select statement for SQL server, with a couple of joins. It just returns a list of products (by category).

What I need to do is have the very first product result be always the same (for just one of the categories). I don't know how to accomplish that. Any advice? TYIA!