Re: SQL Statement

From: Peter Nilsson <>
Date: Tue, 24 Feb 2009 14:12:13 -0800 (PST)
Message-ID: <> wrote:
> Can you have a select statement that returns a literal
> AND normal query results without a UNION?
> Say I have a parameter, like and employee ID, passed to
> a procedure. I want to run a query which returns the top
> 4 records in the result set PLUS the values from the
> employee ID passed in.......So, 5 records total.
> The query is long, so I'm hoping to do it without a
> UNION.......
Why? What have you got against UNION ALL?
Received on Tue Feb 24 2009 - 16:12:13 CST

Original text of this message