SQL – OR Keyword
March 3, 2024
The OR keyword is used with the WHERE keyword to include rows where at least one of multiple conditions are true.
SQL – ORDER BY Keywords
March 3, 2024
The ORDER BY keywords are used to sort the result set using a specified column in ascending order (A – Z) or descending (Z – A) order.
SQL – PRIMARY KEY Keywords
March 3, 2024
The PRIMARY KEY keywords uniquely identifies each record in a table, which can have only one primary key consisting of a single field or multiple fields.
SQL – PROCEDURE Keyword
March 3, 2024
The PROCEDURE keyword is used with the CREATE keyword to create a stored procedure (prepared SQL code to be reused many times).
SQL – RIGHT JOIN Keywords
March 3, 2024
The RIGHT JOIN keywords returns all rows from the right table, and the matching rows from the left table (NULL from the left side if there is no match).
SQL – SELECT Keyword
March 3, 2024
The SELECT keyword is used to select specified data from a database.
SQL – SELECT INTO Keywords
March 3, 2024
The SELECT INTO keywords copies data from one table and inserts it into another table.
SQL – SET Keyword
March 3, 2024
The SET keyword is used with UPDATE to specify which columns and values should be updated in a table.
SQL – TABLE Keyword
March 3, 2024
SQL – TOP Keyword
March 3, 2024
The TOP keyword is used to specify the number of records to return (SQL Server).
SQL – TRUNCATE TABLE Keywords
March 3, 2024
The TRUNCATE TABLE keywords deletes all the data inside a table, but not the table itself.
SQL – UNION Keyword
March 3, 2024
The UNION keyword combines the result set of two or more SELECT statements (returning only distinct values).
SQL – UNION ALL Keywords
March 3, 2024
The UNION ALL keywords combines the result set of two or more SELECT statements (will return duplicate values).
SQL – UNIQUE Keyword
March 3, 2024
The UNIQUE keyword ensures that all values in a column are unique.
SQL – USE Keyword
March 3, 2024
The USE keyword specifies the database you intend to work with. The statement is often made when starting work on or switching to a particular database.
SQL – VALUES Keyword
March 3, 2024
The VALUES keyword specifies the values in an INSERT INTO statement.
SQL – VIEW Keyword
March 3, 2024
The VIEW keyword is used to CREATE a virtual table based on the result set of an SQL statement.
SQL – WHERE Keyword
March 3, 2024
The WHERE keyword filters a result set to include only records that fulfill a specified condition or set of conditions.
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
Why 1SMARTchicken?
This site was built and is maintained to benefit my autistic son.
See More →
See More →
Thanks for your support!
Books
All are affiliate links. Thank you for your support!
