SQL

UNION

SQL UNION Keyword The UNION command combines the result sets of two or more SELECT statements into a single result […]

SQL

TRUNCATE TABLE

SQL TRUNCATE TABLE Keyword The TRUNCATE TABLE command is used to delete all data inside a table without deleting the

SQL

TABLE

SQL TABLE Keyword The TABLE keyword is used in several SQL statements such as CREATE TABLE, ALTER TABLE, DROP TABLE,

SQL

SET

SQL SET Keyword The SET command is used with the UPDATE statement to specify which columns should be updated and

SQL

SELECT TOP

SQL SELECT TOP Keyword The SELECT TOP command is used in SQL Server to return only the top N rows

SQL

SELECT INTO

SQL SELECT INTO Keyword The SELECT INTO command is used to copy data from one table into a new table.

SQL

SELECT DISTINCT

SQL SELECT DISTINCT Keyword The SELECT DISTINCT command is used to return only unique (different) values from a column or

SQL

SELECT

SQL SELECT Keyword The SELECT command is used to retrieve data from a database. The returned data is stored in

SQL

ROWNUM

SQL ROWNUM Keyword The ROWNUM keyword is used in Oracle databases to limit the number of rows returned by a

SQL

RIGHT JOIN

SQL RIGHT JOIN Keyword The RIGHT JOIN command returns all rows from the right table and the matching rows from