InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
In The 'select' Statement What Is "group By"? |
|
Answer» Group by clause is USED to FETCH the data from the table by the specified field ex.select count (*) from emptable group by deptno where deptno = 1. It is used to find the NUMBER of EMPLOYEES PRESENT in the specified department no. Group by clause is used to fetch the data from the table by the specified field ex.select count (*) from emptable group by deptno where deptno = 1. It is used to find the number of employees present in the specified department no. |
|