Answer Detail: RE: Group By

GeekInterview.com > Interview Questions > Mainframe > DB2

Print |

Question: Group By

Answer: Can you select any column in a Group by query even if that column is not groupable?
e.g. Select Dept, Empno, Ave(salary) From T1 Group by Dept
Can we select empno in the above query?

August 08, 2008 06:54:52	#1
Upendrapcu	Member Since: July 2008 Total Comments: 1
RE: Group By
Yes we can select the emp no field

Back To Question