четверг, 1 сентября 2016 г.

Синтаксис SQL запросов

Зачетный сайт http://sqlcom.ru/

SQL Basic

HOME
Intro
Syntax
SELECT
SELECT DISTINCT
WHERE
AND & OR
ORDER BY
INSERT INTO
UPDATE
DELETE
Injection
SQL Advanced
SELECT TOP
LIKE
Wildcards
IN BETWEEN
Aliases Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
UNION
SELECT INTO
INSERT INTO SELECT
CREATE DB
CREATE TABLE
Constraints
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK DEFAULT
CREATE INDEX
DROP
ALTER
Auto Increment
Views Dates
NULL Values
NULL Functions
General Data Types
DB Data Types
 SQL Functions

Functions
AVG()
COUNT()
FIRST()
LAST()
MAX()
MIN()
SUM()
GROUP BY
HAVING
UCASE()
LCASE()
MID()
LEN()
ROUND()
NOW()
FORMAT()
Quick Ref
Hosting
Summary

SQL Quiz
Quiz

Комментариев нет:

Отправить комментарий