the title of your post "In --> Group By with Multiple columns...> how it will responds " is not enough for us to go by;
can you explain your question better? do you have a coded example that's not working as expected?
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!