wide_compute.c sample program

The wide_compute.c sample program demonstrates how to process compute results with wide tables and larger column sizes. It:

NoteThis sample requires the pubs2 database.

This is the query:

select type, price from titles 
where type like "%cook" 
order by type, price 
compute sum(price) by type 
compute sum(price)

This query returns both regular rows and rows that are returned by a compute clause. The computed rows are generated by the two compute clauses: