Home » RDBMS Server » Server Administration » help with query
help with query [message #371972] Thu, 28 December 2000 09:54
archna
Messages: 1
Registered: December 2000
Junior Member
I have this query:

select distinct x.channel,x.name,y.prod-id,y.prod-rel,y.system-name,z.description__1 from t-channel x,p-attribute z,o-matrix y where x.channel=y.channel and y.prod-id = z.prod-id and x.channel >= '244' order by x.channel

It works fine. How can I use group by for channel as I want to use count fn with it like count(channel).

Thanks,
archna

Report message to a moderator

Previous Topic: Procedure Help
Next Topic: Call Procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 19:00:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.