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;
Want to see the full answer?
Check out a sample textbook solutionChapter 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