Database - Database Design Using Normalization - Discussion

Discussion :: Database Design Using Normalization - General Questions (Q.No.5)

5. 

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

[A]. The multivalue, multicolumn problem
[B]. The inconsistent values problem
[C]. The missing values problem
[D]. The general-purpose remarks column problem

Answer: Option B

Explanation:

No answer description available for this question.

Shikha said: (Jun 6, 2011)  
Kindly explain how?

Archana said: (Jan 17, 2012)  
Please explain me how.

Divyans said: (May 3, 2012)  
Please explain..

Rakesh said: (Apr 27, 2013)  
Firstly usage of group by in select statement is to get the content by reference with one column like.

Select max(esal) from emp group by dept;.

Then it gives us the max salary in department wise, We may have many employees are working in a department so we can organize it in department wise, by this we can get only the particular department details although we have the duplicate values in salary, so we get consistent data.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.