Re^4: How to add columns with new row name using perl from mysql query?

in reply to Re^3: How to add columns with new row name using perl from mysql query?
in thread How to add columns with new row name using perl from mysql query?

Hai,
Here the row others prints as NULL which as follows.How can i add data type for the others row in the below sql query.

| others        |         NULL |         NULL |
[download]

SELECT queue_name, jobs_pend, jobs_run FROM (
    SELECT queue_name, jobs_pend, jobs_run
        FROM queues
        ORDER BY queue_name
        LIMIT 5
) UNION ALL
SELECT 'others', SUM(jobs_pend) AS jobs_pend, SUM(jobs_run) AS jobs_ru
+n FROM (
    SELECT jobs_pend, jobs_run
        FROM queues
    ORDER BY queue_name
    LIMIT 5 OFFSET 5
)
[download]

In Section Seekers of Perl Wisdom