Adding empty row in result set?

[Sleidia]

Hi guys

In a select query, what do I add in order to add an empty row either at the very top or at the very bottom of the result table even if the result set is empty?

Thanks!

 

[r937]

select ...
   [i]your query here, without the ORDER BY[/i]
union all
select null, null, ... [i]one per column in your select[/i]
order by [i]your ORDER BY[/i]

r937.com | rudy.ca

 

[Sleidia]

Wow thanks!
To my credit, I was very close to the solution ahaha

 

[Sleidia]

Hello again Rudy,

I've noticed that the extra row doesn't show when the table is empty

Is there a way to show the extra empty row even when the table is empty?

Thanks!

 

[Sleidia]

Ooop sorry, everything is OK ahaha