Tables. How to set up additional header and footer for a table

To do this, specify the table SELECT 4

The columns must repeat the order of the columns in the table (and there may be more of them for, for example, to pass the order or isHead=1, but you need to add them to the end). 

Examplt: 

select * from (
    select 'BEFORE PERIOD' x1,
          2 x2,
		  3 x3,
          4 x4,
          1 ord,
      	  1 isHead
	union
    select 'SALDO' x1,
          2 x2,
		  3 x3,
          4 x4,
          2 ord,
      	  0 isHead
    union
	select 'AFTER PERIOD' x1,
          2 x2,
		  3 x3,
          4 x4,
          3 ord,
      	  0 isHead
) t1 order by ord

In this case, add 1 line to the header and 2 lines to the footer:

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

 
Note