IBM DB2 Question:

Can GROUP BY and ORDERED BY used in a single query?

IBM DB2 Interview Question
IBM DB2 Interview Question

Answer:

YES we can use and Group by must come in order to code query.Ex. select * from tab01 group by col1 order by col02

YES we can use and Group by must come in order to code query.Ex. select * from tab01 group by col1 order by col02


Previous QuestionNext Question
What is DCLGEN ?Can you have more than one cursor open at any one time in a program ?