Database - Database Design Using Normalization - Discussion
Discussion Forum : 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?
Discussion:
4 comments Page 1 of 1.
Rakesh said:
10 years ago
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.
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.
Divyans said:
1 decade ago
Please explain..
Archana said:
1 decade ago
Please explain me how.
Shikha said:
1 decade ago
Kindly explain how?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers