Tutorialspoint examples

Learn java tutorial with examples for beginners online

SQL GROUP BY clause

The GROUP BY clause is used to group the identical data by one or more columns. It is used with the aggregate functions in the select statement.… Read More

SQL ORDER BY Clause

The ORDER BY Clause is used to sort the results either in ascending or descending order based on one or more columns. Oracle and some other database… Read More

SQL UNION Operator

SQL UNION Operator. The UNION operator is used to combine the result sets of two or more SELECT statements. For UNION, every SELECT statement must have same… Read More

SQL OR Clause

The OR clause is also known as conjunctive operator and used to combine multiple conditions in SQL statement. Syntax: SELECT * FROM tableName WHERE [condition1] OR [condition2]…OR… Read More

SQL AND Clause

The AND clause is also known as conjunctive operator and used to combine multiple conditions in SQL statement. Syntax: SELECT * FROM tableName WHERE [condition1] AND [condition2]…AND… Read More

SQL ALIAS Statement

The ALIAS statement is used to temporarily rename a table or column in a SQL statement. Syntax: SELECT columnName AS columnAliasName FROM tableName As tableAliasName; Example: SELECT… Read More

SQL NOT BETWEEN Operator

The BETWEEN operator is used to select values within a range. The values can be numbers, dates or text. Syntax: SELECT * FROM tableName WHERE columnName NOT… Read More

SQL BETWEEN Operator

The BETWEEN operator is used to select values within a range. The values can be numbers, dates or text. Syntax: SELECT * FROM tableName WHERE columnName BETWEEN… Read More
Copyright © 2018 Tutorialspoint examples DMCA.com Protection Status