What is GROUP BY and ORDER BY Clause in DB2

shrikanth_m · New User Joined: 19 Jan 2007 Posts: 5 Location: bangalore

Can some one explain me what is GROUP BY and ORDER BY Clause in DB2, i would be greateful if i get with proper example,.

Thanks in advance!
Regards
Srikanth

dick scherrer · Posted: Sun Jan 21, 2007 9:59 pm

Hello,

GROUP BY specifies a summary query.
ORDER BY identifies what sequence rows should be returned.

I'd recommend you download the IBM manuals (free) and/or purchase a book on SQL (wide price range - amazon.com has many).