![Database Systems: Design, Implementation, & Management](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_largeCoverImage.gif)
Concept explainers
“GROUP BY” Clause:
The GROUP BY clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column.
Syntax:
SELECT expression1, expression2, expression_n, aggregate_function (expression) FROM table_name WHERE conditions GROUP BY expression1, expression2, expression_n;
DISTINCT Keyword: “DISTINCT” keyword is used to avoid redundant data (removing duplicate values) from a column. The syntax for “DISTINCT” keyword is as follows:
Syntax:
SELECT DISTINCT column_Name FROM table_Name;
Join: Join is a relational operation, which combines the data from two or more tables into single table or view, then that is called as Join.
Inner join: The “inner join” keyword is to select the matching records from two tables. The syntax of “inner join” is as follows:
Syntax:
SELECT column_name FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name;
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 7 Solutions
Database Systems: Design, Implementation, & Management
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)