IBM DB2 Question:

Download Job Interview Questions and Answers PDF

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

Download IBM DB2 Interview Questions And Answers PDF

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