SQL's GROUPBY logic

pas30339 · #1 (**permalink**) 02-25-05, 20:01

I'm attempting to code what amounts to a GROUPBY in SQL.

Essentially I have a sort routine that I would like to modify so as to provide grouping by category.

Does anyone know the logic SQL typically employs to effect groupby?

r937 · #2 (**permalink**) 02-25-05, 22:41

you'll need to give an example

based on what you've said, ORDER BY is what you want

pas30339 · #3 (**permalink**) 02-26-05, 00:03

Quote:

Originally Posted by r937

you'll need to give an example

based on what you've said, ORDER BY is what you want

You are entirely correct! Doh!

I'll have n number of items each with a bitflag identifier, the bitflag being one of 7 possible values, and they need to be displayed in a predetermined order.

I think that the entire reason for the post is now null as i should be able to accomplish what I need in the sorting.

Thanks.

I need to back away from the computer for a while now. LOL!!

r937 · #4 (**permalink**) 02-26-05, 05:24

a bitflag with 7 possible values? this i gotta see

Internet Services

Web Development

Digital Marketing

Consumer Tech