Post reply

Doubt in GroupBy Clause

  • March 23, 2006 at 9:49 am

    #365582

    Is it possible to add a blank row after each group by records.

    for eg:

    Dept Name

    1 fff

    1 adf

    2 ccc

    3 fdg

    It should be:

    Dept Name

    1 fff

    1 adf

    2 ccc

    3 fdg

    OR

    Dept Name

    1 fff

    adf

    2 ccc

    3 fdg

  • March 24, 2006 at 4:48 am

    #628553

    In general, no, not in the query. Formatting such as this (between rows) is usually done by the client program. The query itself just returns a relation (table). Your second result is not even a table, because the rows do not have the same number of columns.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply