At 02:37 PM 17/04/2010, you wrote:

>Hi All,
>
>
>I have a small doubt(and requirement also), if i am executing an sql statement and it is giving 10 records as an output, is it possible to get some extra rows with this output with some initial values or with no values for specified or for all columns.
>
>For example, if i am getting 10 records as an output, is it possible to get an extra records means total 11 records (i.e. one extra record with or without values).
>
>As per my efforts it seems to be not possible, but still i would like to clarify this doubt.
>
>But i would like to do this effort with sql statement.

SELECT F1, F2, F3,.... etc..../* your real data */
WHERE...
UNION
SELECT '', null, 0, ...etc... /* your dummy row, literals matching types 1:1 */

(But why???)

N.B. This is not an updatable set.

Dom