SQL TUTORIAL

SQL ALIAS

This tutorial shows you how to use SQL alias including column and table aliases to make your queries shorter and more understandable.

sql alias column name

SQL ALTER TABLE

This can be achieved in SQL. To do this, we specify that we want to change the table structure via the ALTER TABLE command.

add column to table sql

SQL AND OR

The AND operator can be used to join two or more conditions in the WHERE clause. Both sides of the AND condition must be true in order for the condition to be executed.

sql and command

SQL AUTO INCREMENT

A short hint: In most cases auto-increment columns are used as Primary Key columns. In the SQL standard the junction of the two concepts is not mandatory.

alter table auto-increment

SQL BETWEEN

This SQL tutorial explains how to use the SQL BETWEEN condition with syntax and examples.

between mssql

SQL CHECK

SQL CREATE TABLE with constraint to exclude NULL value; SQL CREATE TABLE to check unique value; SQL CREATE TABLE to check.

sql server constraint check

SQL CREATE TABLE

This SQL Server tutorial explains how to use the CREATE TABLE statement in SQL Server (Transact-SQL) with syntax and examples.

create table in sql server

SQL DEFAULT

The DEFAULT value clause in a data type specification indicates a default value ... MySQL handles the column according to the SQL mode in effect at the time:.

sql column default value

SQL DELETE

The SQL DELETE Query is used to delete the existing records from a table. You can use WHERE clause with DELETE query to delete selected rows, otherwise all rows will be deleted.

sql delete statement

SQL DISTINCT

SQL SELECT DISTINCT with COUNT on ROWS or on one columns. ... SQL Keywords ... SELECT DISTINCT eliminates duplicate records from the results.

access select distinct

SQL FOREIGN KEY

This tutorial introduces you to MySQL foreign key and shows you step by step how to create.

primary key and foreign key

SQL FULL JOIN

SQL Full Join (Full Outer Join) always contains all records of left table (Table A) and right table (Table B) even of join condition does not find any matching records.

full outer join syntax

SQL GROUP BY

The GROUP BY clause will gather all of the rows together that contain data in the specified column(s) and will allow aggregate functions to be performed on the grouped data.

mssql group by

SQL HAVING

The SQL HAVING clause is used in combination with the GROUP BY clause to restrict the groups of returned rows to only those whose the condition is TRUE.

sql where having

SQL IN

In SQL, there are two uses of the IN keyword, and this tutorial explain the one that is related to sql or operator.

sql in statement

SQL INNER JOIN

how to use MySQL INNER JOIN clause to select data ... The MySQL INNER JOIN clause matches rows in one table with rows in other tables.

sql server inner join

SQL INSERT INTO

SQL has the INSERT command that is used to store data into a table. The INSERT command creates a new row in the table.

insert into multiple rows

SQL INSERT INTO SELECT

A common task when using Transact-SQL (T-SQL) is to copy information from one table into another, possibly changing the data or its structure.

insert into select t sql

SQL LEFT JOIN

The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2).

left join where

SQL LIKE

The SQL LIKE operator is only applies on a field of types CHAR or VARCHAR to match a pattern using SQL wildcards.

like in sql server

SQL NOT NULL

This tutorial introduces you to SQL NOT NULL constraint and shows you how to add the NOT NULL constraints to existing columns.

sql server is not null

SQL ORDER BY

The ORDER BY keyword sorts the records in ascending order by default. To sort the records in a descending order, you can use the DESC keyword.

sql order by number

SQL PRIMARY KEY

A primary key is a field in a table which uniquely identifies each row/record in a database table. ... A primary key column cannot have NULL values.

create table with primary key

SQL RIGHT JOIN

SQL Right Join (Right Outer Join) always contains all records of right table even of join condition does not find any matching record in left table.

sql left right

SQL SELECT

The result of a SELECT is zero or more rows of data where each row has a fixed number of columns. A SELECT statement does not make any changes to the database.

select in select sql server

SQL TOP

Limits the rows returned in a query result set to a specified number of rows or percentage of rows in SQL Server 2016. When TOP is used in conjunction with the other table.

sql server top 1

SQL UNION

UNION is used to combine the result from multiple SELECT statements into a single result set.

access sql union

SQL UNIQUE

It is possible to put UNIQUE constraints on nullable columns but the SQL standard states that the constraint does not support duplicate values.

add unique constraint oracle

SQL UPDATE

For the multiple-table syntax, UPDATE updates rows in each table named in table-references that satisfy the conditions. Each matching row is updated once, even if it matches the conditions multiple times. For multiple-table syntax, ORDER BY and LIMIT cannot be used.

update command in sql

SQL WHERE

The SQL WHERE clause is used to specify a condition while fetching the data from single table or joining with multiple tables. If the given condition is satisfied then only it returns specific value from the table.

sql where not