Прості запити мовою SQL

Structured Question Language

Strong Question Language

Structured Query Language

EXTRACT

GET

SELECT

OPEN

MODIFY

UPDATE

EDIT

SAVE

DELETE

REMOVE

COLLAPSE

ERASE

SELECT *.Persons;

SELECT Persons;

SELECT ALL FROM Persons;

SELECT * FROM Persons;

SELECT * FROM Persons ORDER BY FirstName DESC;

SELECT * FROM Persons SORT BY FirstName DESC;

SELECT * FROM Persons SORTED FirstName DESC;

SELECT * FROM Persons SORT FirstName;

INSERT ('Jimmy','Jackson') INTO Persons;

INSERT INTO Persons VALUES ('Jimmy','Jackson');

INSERT VALUES ('Jimmy','Jackson') INTO Persons;

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen';

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen';

UPDATE Persons SET LastName='Nilsen' INTO LastName='Hansen';

MODIFY Persons SET LastName='Nilsen' INTO LastName='Hansen';

DELETE FirstName='Peter' FROM Persons;

DELETE RECORD FirstName='Peter' FROM Persons;

DELETE FROM Persons WHERE FirstName='Peter';

SELECT * FROM Persons WHERE FirstName LIKE 'a%';

SELECT * FROM Persons WHERE FirstName='a';

SELECT * FROM Persons WHERE FirstName =  '%a%';

SELECT * FROM Persons WHERE FirstName LIKE '%a';

Групування даних поля Comm за певними ознаками

Сортування таблиці S по полю Comm за зростанням

Групування всіх даних поля Comm

Сортування таблиці S по полю Comm за вбуванням

DELETE FROM Users WHERE reg_date LESS THEN ’01-01-2020’;

DELETE FROM Users WHERE reg_date <  ’01-01-2020’;

REMOVE FROM Users WHERE reg_date <  ’01-01-2020’;

%

_

?

*

#

SELECT * FROM Persons WHERE FirstName <> ‘Peter’ AND LastName <> ’Jackson’

SELECT * FROM Persons WHERE FirstName = ‘Peter’ AND LastName = ’Jackson’

SELECT FirstName = ‘Peter’, LastName = ’Jackson’ FROM Persons

INSERT VALUES (‘user3000’, now()) INTO Users

INSERT Users FROM VALUES (‘user3000’, now())

INSERT INTO Users (name, reg_date) VALUES (‘user3000’, now())

ADD Users (name, reg_date) RECORD(‘user3000’, now())

GET

EXTRACT

SELECT

OPEN

SELECT COUNT (*) FROM Users

SELECT UNION (*) FROM Users

SELECT len (*) FROM Users

SELECT COLUMNS (*) FROM Users

CREATE TABLE

CREATE DATABASE TABLE

CREATE TABLE IN DATABASE

CREATE DB

SELECT Persons

SELECT  All  From  Persons

SELECT *. Persons

SELECT * FROM Persons

SELECT * FROM users ORDER BY reg_date DESC

SELECT * FROM users SORT BY reg_date DESC

SELECT * FROM users ORDER BY reg_date ASC

SELECT * FROM users ORDER ASK BY reg_date

SELECT * FROM users SORT BY (reg_date)

SELECT * FROM Persons WHERE FirstName = ‘a’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName STARTSWITH  ‘a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName = ‘%a%’

SELECT City, COUNT (Comm) FROM  S GROUP BY City;

SELECT City, AVG (Comm) FROM  S GROUP BY City;

SELECT City, AVG (Comm) FROM  S ORDER BY City;

SELECT City, COUNT (Comm) FROM  S ORDER BY City;

HAVING

WHERE

FROM

INTO

SELECT * FROM  Client WHERE Email IS NULL;

SELECT * FROM  Client WHERE Email=NULL;

SELECT * FROM  Client WHERE Email=0;

SELECT * FROM  Client WHERE Email IS NOT;

INSERT INTO Client (ID, Surname, Country, City, Email) VALUES (2, 'Ющенко', 'Україна', 'Київ')

INSERT INTO Client (Surname, Country, City, ID, Email) VALUES ('Ющенко', 'Україна', 'Київ', 2, NULL)

INSERT INTO Client (ID, Surname, Country, City, Email) VALUES (2, 'Ющенко', 'Україна', 'Київ',  NULL)

INSERT INTO Client ( Surname, ID, Country, City, Email) VALUES (2, 'Ющенко', 'Україна', 'Київ',  NULL)

INSERT Client (ID, Surname, Country, City, Email) INTO VALUES (2, 'Ющенко', 'Україна', 'Київ',  NULL)

Павельчак

Ющенко

Лукашенко

Повідомлення про помилку, бо функцію MIN неможливо застосовувати для полів з типом даних nchar