Concept explainers
SELECT statement: It is used to retrieve information from the table or
SELECT * FROM table_Name;
WHERE clause: “WHERE” statement is used limit the number of rows.
For example: Consider a table “FTable” that has two columns named “FruitName” and “Color”. “WHERE” clause is used when there is a need to display the entire FruitName whose color is Red.
SELECT * FROM FTable WHERE color = 'red';
When the above statement is executed, red colored fruits get displayed.
“COUNT()” function:
In SQL, the “COUNT ()” function will return the total number of rows in the table with satisfying the criteria mentioned in the “WHERE” clause.
GROUP BY Clause:
The GROUPBY 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;
Want to see the full answer?
Check out a sample textbook solutionChapter 7 Solutions
Database Systems: Design, Implementation, & Management
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning