Question & Additional Information
 
Is the WHERE clause must appear always before the GROUP BY clause in SQL SELECT ?
Add to My IQ
 

Answer Title
Answer
Yes. The proper order for SQL SELECT clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.  Only the SELECT and FROM clause are mandatory.
Question Tag Title
Tags
Question Asked At Title
Asked At
None
Question Job Title
Job Titles
None


Check out our newest job listings!

Post a Job! $49 for 60 days



Your Name:
Add your comment text
 
Related Questions
Related Questions
Flag this interview question as inappropriate Inappropriate
See Answer
I am a part of my group when we are in college year. And I always play role as the team leader and I divide the tasks for them.
Create Date
:
Tuesday, March 18, 2008
Asked At
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
Selection Process

Selection is the process of choosing from a group of applicants those individuals best suited for a particular
position. Most managers recognize that employee selection is one of their most difficult, and most important,
business decisions. This process involves making a judgment -not about the applicant, but about the fit
between the applicant and the job by considering knowledge,skills and abilities and other characteristics required to perform the job Selection procedures are not carried out through standard pattern and steps in this. Process can vary from organization to organization some steps performed and considered important by one organization can be skipped by other organization.
Environmental Factors Affecting the Selection Process A permanent, standardized screening process could greatly simplify the selection process. However, development of such a process even if it were possible and desirable would not eliminate deviations to meet the unique needs of  particular situation.

Legal Considerations
Legislation, executive orders, and court decisions have a major impact on human resource management. It is important for hiring managers to see the relationship between useful and legally defensible selection tools.

Speed of Decision Making
The time available to make the selection decision can have a major effect on the selection process. Closely following selection policies and procedures can provide greater protection against legal problems; however, there are times when the pressure of business will dictate that exceptions be made.

Organizational Hierarchy
Different approaches to selection are generally taken for filling positions at different levels in the organization.

Applicant Pool
The number of applicants for a particular job can also affect the selection process. The process can be truly
selective only if there are several qualified applicants for a particular position. The number of people hired for a particular job compared to the individuals in the applicant pool is often expressed as a selection ratio.

Type of Organization
The sector of the economy in which individuals are to be employed private,  governmental, or not-forprofit can also affect the selection process.

Probationary Period
Many firms use a probationary period that permits evaluating an employee's ability based on performance. This may be either a substitute for certain phases of the selection process or a check on the validity of the process.

Selection Criteria
Mostly the selection of applicant depends upon the
following factors or criterions.
1. EDUCATION
2. COMPETENCIES
3. EXPERIENCE
4. SKILLS AND ABILITIES
5. PERSONAL CHARACTERISTICS

Applicant who is best fit should be hired instead of hiring a person with extra ordinary skills it means right person for right job should be hired person who is over or under qualified for the particular job will not be able to adjust in the organization.

STEPS IN THE SELECTION PROCESS
The selection process typically begins with the preliminary interview; next, candidates complete the application for employment. They progress through a series of selection tests, the employment interview, and reference and background checks. The successful applicant receives a company physical examination and is employed if the results are satisfactory. Several external and internal factors impact the selection process, and the manager must take them into account in making selection decisions. Typically selection process consists of the following steps but it is not necessary that all organization go through all these steps as per requirement of the organization some steps can be skipped while performing the selection process.
1. Initial Screening
2. Application Blank
3. Pre-employment Testing
. General Intelligence Tests
. Aptitude Tests
. Personality and Interest Tests
. Achievement Tests
. Honesty Tests
4. Interview
. Structured Interview
. Unstructured Interview
. Mixed Interview
5. Background Checks
6. Conditional job offer
7. Medical Exam/Drug Tests
8. Final Selection Decision
Create Date
:
Monday, March 17, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
On AIX use  --
groups -To Display full list
id -G - To display group id number

On Solaris use --
groups - To display full list
id -a - To diaplsy full list of groups with group id numbers

Create Date
:
Wednesday, March 19, 2008
Tags
:
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
Referential Integrity defines that the Primary key of one table should be match to the foreign key of other tables .
 
Create Date
:
Saturday, May 10, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
There are numerous good possibilities:
Loyalty, Energy, Positive attitude, Leadership, Team player, Expertise, Initiative, Patience, Hard work, Creativity, Problem solver.
Click here to improve the Interview Question, Answer and other fields.
Comments (1) :
1.
bbfromdc
Sunday, October 12, 2008 8:02 AM
I simply love my supervisor Is it okay ?
Flag this interview question as inappropriate Inappropriate
See Answer
If you have done your homework about this organization, now is the time to use that knowledge. Remember, even as a recruited candidate, some facilities will want to understand why you would select them. If you are a recruited candidate, remind them that you were not looking when you were contacted, but that the challenge sounded intriguing and that a solid opportunity for career advancement is important to you.
Create Date
:
Thursday, March 20, 2008
Tags
:
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (1) :
1.
tt2tt
Friday, July 04, 2008 10:41 AM
Y so many answers for the same question ?
 
• More Related Questions: 
Suggestions & Comments




Share Your Interview Questions
Ask Interview Questions
View Unanswered Questions

















Advertise on this site