DB2 - Group By

GeekInterview.com > Interview Questions > Mainframe > DB2

Go To First | Previous Question | Next Question

DB2 | Question 194 of 195

Group By

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?

Total Answers and Comments: 1

Last Update: August 07, 2008 Asked by: madhurap

What is Data Attribute Group

In data modeling, a logical data model is the representation of business data into a data model that can be the basis for the physical database implementation. It identifies a data "periodic table" which will be the basis for the business functions, processes and task to be perfor

Advertising Copy Group Head Career

Every department in any profession needs a supervisor who overlooks the work of everyone else. This person obviously needs to be well experienced in the respective field, and should also be good with people management. He or she should be able to identify mistakes and correct them. Overall, the job

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve

HR Interview - Telephone Interview Etiquette

Telephone Interview Etiquette When you conduct a telephone interview for a job it is important to show the proper etiquette Not only is it important it is critical is you wish to be hired by the company There are a number of things you will want to do and other things should never be done mosgoogle