SQL Keywords With Examples

SQL keywords are the reserved words for SQL operations. These Keywords are used across SQL version for different functionalities.

SQL Keywords

SQL keywords are case insensitive. So the keyword SELECT and select will behave in the same way. Let’s look at some of the commonly used SQL keywords.

  1. ALTER TABLE: ALTER TABLE is used for altering column of a table.

    Output: On execution of this command a column will get added to the table table_name.
  2. AND: AND is an sql operator which is used for adding multiple condition. If the conditions are satisfied by a row. It will be part of the result set.

    Output: On execution of this command, if column1 is equal to value1 and column2 is equal to value2 then only the row will be qualified for result set.
  3. AS: AS is used for aliasing a column or table.

    Output: On execution of this command, the result will display column_name as ‘Alias’.
  1. AVG: AVG is an aggregate function which will provide the average of the numeric column.

    Output: Execution of this command will provide the average of column_name.
  2. BETWEEN: BETWEEN is an operator which is used for defining a set. The value for range can be numeric, text and date.

    Output: Execution of this command will give a result set bounded by value1 and value2.
  3. COUNT: COUNT is a function which provides the count of the row for a column. The column should be a not null column.

    Output: On execution of this command, the result will contain the count of the rows for column_name.
  4. CREATE TABLE: This command is used to create table in the database. It allows to specify the name of the table along with the name a datatype of the column.

    Output: Execution of this command will result in creation of table with name as table_name along with column1 and column2 as the columns of the table.
  5. DELETE: DELETE is the command which is used for removing rows from the table

    Output: On execution of this command the rows that will be selected based on the condition in the WHERE clause will be deleted.
  1. GROUP BY: GROUP BY is a clause in SQL that is only used with aggregate functions. It is used along with the SELECT statement to arrange identical data into groups.

    Output: Execution of this order will result in grouping the result set based on the column_name.
  2. INNER JOIN: INNER JOIN will select records with matching values in two tables.

    Output: Above command will result in rows where both tables have matching values for column_name.
  3. INSERT: INSERT is used for adding a new row in the table.

    Output: Execution of this command will result in addition of a new row with values corresponding to the columns.
  4. LIKE: LIKE is an operator which is used for specifying a pattern. This operator is used along with WHERE clause.

    Output: Output will the rows that will satisfy the like pattern.
  5. LIMIT: LIMIT is a clause which allows the restricting the result set rows to maximum number specified by the limit clause.

    Output: The resultset will be limited by the number that is provided as part of the limit clause.
  6. MAX: MAX is a function that will return the max value from the column specified.

    Output: The output will the maximum value specified in the column column_name.
  7. MIN: MIN is a function that will return the min value from the column specified.

    Output: The output will the minimum value specified in the column column_name.
  1. OR: OR is the operator that is used for selecting the rows based on satisfaction of either condition in WHERE clause.

    Output: Result set will contain rows where column_name value will be either value1 or value2.
  2. ORDER BY: ORDER BY is used for sorting of columns in ascending or descending order numerically or in alphabetical order.

    Output: On execution of the command above we will get the result set in ascending order.
  3. LEFT JOIN, RIGHT JOIN: These will combine rows from different tables even if the join condition is not met. Every row in the left/right table is returned in the result set, and if the join condition is not met, then NULL values are filled in the columns from the left/right table.

    Output: Execution of the command above will result in rows from the table_1 along with rows which satisfies the condition from table_2

    Output: Execution of the command above will result in rows from the table_2 along with rows which satisfies the condition from table_1.
  4. ROUND: ROUND is a function that rounds of the number specified in the column based on the integer that is specified as part of the function.

    Output: The output of the command will result in rounding up the number based on the integer that is provided as part of the function.
  5. SELECT: SELECT is used to fetch the data from the data base.

    Output: On execution of this command the result set will contain rows for column column_name.
  6. SELECT DISTINCT: SELECT DISTINCT is used for retrieving distinct values from the column that is specified.

    Output: On execution of the command above the result set will only contain the unique values from the column column_name.
  7. SUM: SUM is a function will provides the total value of a column which is numeric.

    Output: Execution of this command will result in the total of all the row that are part of the column column_name.
  8. UPDATE: UPDATE is used for updating values of a row of a table.

    Output: Execution of this command will result in updating the row that will satisfy the condition in the where clause.
  9. WHERE: WHERE is used for specifying the condition that should be satisfied for selecting the row to be part of the result set.

    Output: The output of this command will result in the rows that are satisfying the where clause.

That’s all for a quick roundup on mostly used SQL keywords.

Reference: Oracle SQL Reserved Words List

By admin

Leave a Reply