Answer Detail: RE: Can GROUP BY and ORDERED BY used in a single query...

GeekInterview.com > Interview Questions > Mainframe > DB2

Print |

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

December 12, 2005 12:10:19	#2
Vinod Maanju	Member Since: Visitor Total Comments: N/A
RE: Can GROUP BY and ORDERED BY used in a single query...
YES we can use and Group by must come in order to code query.Ex. select * from tab01 group by col1 order by col02