How to make this

[musefan]

:confused:

I may or may not be responsible for my own actions

[Nath]

what are you trying to say

[musefan]

Your post makes very little sense. Can you try and better explain what you are trying to do as at the moment all you have is a list of poorly formatted values

I may or may not be responsible for my own actions

[Ali Al Omairi Abu AlHassan]

do you mean you want to group data?. if so, use [order by](http://www.w3schools.com/sql/sql_orderby.asp).

Help people,so poeple can help you.

modified on Friday, March 11, 2011 2:16 PM

[Klaus Werner Konrad]

How can ORDER BY help in GROUPING data ? (I think you meant GROUP BY)

[Klaus Werner Konrad]

My be this will work (in SqlBase it works): SELECT Title, TO_CHAR( COUNT(*), 0), NULL FROM Table GRUOP BY Title UNION SELECT Title, UserName, UserSite FROM Table ORDER BY 1, 2, 3

[Ali Al Omairi Abu AlHassan]

or group by, but why to use it scinse there is no need to use aggregate functhins. in addition order by also sort data 100 :rose:

Help people,so poeple can help you.

[Klaus Werner Konrad]

Of course he need a aggregate function, for the title count ...

[Ali Al Omairi Abu AlHassan]

So, you are the one with the answer below. ok i admit that i misread. shall you forgive my mistake! :-D 100 :rose:

Help people,so poeple can help you.

[Ali Al Omairi Abu AlHassan]

As they say "Think twice before you leap !". Have a 5 100 :rose:

Help people,so poeple can help you.

[Klaus Werner Konrad]

I'll forgive you :-)))) Just wondered that you said 'grouping items' and than advise 'order by' - that confused me Anyway, I'm glad to be able to share your community ! Regards, kwk

[Ali Al Omairi Abu AlHassan]

Klaus-Werner Konrad wrote:

that confused me

you shouldn't be (i am not familiar with database) :-D 100 :rose:

Help people,so poeple can help you.