Control Output

[caradoc]

I am using db2 database. I want to control the presentation of the rows in my final output. How can I achieve this.

[Rahulbatra]

One way to control the presentation of the rows in final output is to use Group by. I assume you know the syntax and usage of this. If not let me know and I will explain here in detail.

[Angela]

Rahul thanks for your valuable input. It would be great if your could give me th syntax also with example so that I could try it out.

[Rahulbatra]

Suppose you have a emp table with empname column you can associate columns having same empname as below:
SELECT empname, COUNT(*) from emp GROUP BY empname

Let me know if you have any doubts.