|
SQL
Products (Sort), ( Product)
| SELECT Product, Sort, Price FROM Products ORDER BY Sort, Product;
| SELECT Product, Sort, Price FROM Products ORDER BY 2,3;
| SELECT Product, Sort, Price FROM Products ORDER BY 2, 1
| SELECT Product, Sort, Price FROM Products ORDER BY Sort, 1;
|
|
WHERE USA Canada?
| Country = 'USA' AND Country ='Canada'
| Country = 'USA' OR Country ='Canada'
| Country IN (USA, Canada)
| Country IN (USA AND Canada)
|
|
"First Name" "Persons".
| SELECT Persons, FirstName;
| SELECT FirstName FROM Persons;
| Update FirstName FROM Persons;
| Update FirstName SET Persons;
|
|
"Persons" , "FirstName" "Peter".
| SELECT [all]
FROM Persons like FirstName: 'Peter'
| SELECT *
FROM Persons
WHERE FirstName: 'Peter'
| SELECT *
FROM Persons like 'Peter'
| SELECT *
FROM Persons
WHERE FirstName = 'Peter'
|
|
"Persons" , "FirstName" 'a'.
| SELECT *
FROM Persons
WHERE FirstName LIKE 'a%'
| SELECT *
FROM Persons LIKE FirstName '%a'
| SELECT *
FROM Persons
WHERE FirstName = 'a'
| SELECT *
FROM Persons
WHERE FirstName LIKE '%a'
|
|
"Persons" , "FirstName" 'n'.
| SELECT *
FROM Persons
WHERE FirstName LIKE 'n%'
| SELECT *
FROM Persons
LIKE FirstName '%n'
| SELECT *
FROM Persons
WHERE FirstName = 'n'
| SELECT *
FROM Persons
WHERE FirstName LIKE '%n'
|
|
"Persons" , "FirstName" 'Peter' "LastName" 'Jackson'.
| SELECT *
FROM Persons
WHERE FirstName = 'Peter' AND LastName = 'Jackson';
| SELECT FirstName = 'Peter', LastName = 'Jackson' FROM Persons;
| SELECT FirstName AND LastName FROM Persons
WHERE FirstName = 'Peter' AND LastName = 'Jackson';
| SELECT ALL*
FROM Persons
WHERE FirstName = 'Peter' AND LastName = 'Jackson';
|
|
"Persons" , "LastName" ( .. ) "Hansen" "Pettersen.
| SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons;
| SELECT *
FROM Persons
WHERE LastName BETWEEN 'Hansen' AND 'Pettersen';
| SELECT *
FROM Customers
WHERE LastName > 'Hansen' AND 'LastName < Pettersen';
| SELECT *
FROM Persons
WHERE LastName > 'Hansen', LastName <= 'Pettersen';
|
|
"Persons" , "Birthday" 2009 . ( SQL Jet)
| SELECT *
FROM Persons
WHERE Birthday > 01.06 AND Birthday < 31.08;
| SELECT *
FROM Persons
WHERE Birthday BETWEEN #06/01/2009# AND #08.31.2009#;
| SELECT *
FROM Persons
WHERE Birthday BETWEEN AND ;
| SELECT *
FROM Persons
WHERE Birthday BETWEEN #01.06.2009# AND #31.08.2009#;
|
|
'Persons', FirstName .
| SELECT *
FROM Persons
ORDER BY - 'FirstName';
| SELECT *
FROM Persons
ORDER BY 'FirstName' DESC;
| SELECT *
FROM Persons
WHERE FirstName ORDER BY 'FirstName' DESC;
| SELECT *
FROM Persons SORT REVERS 'FirstName';
|
|
c 'Jimmy', 'Jackson' 'Persons'.
| INSERT INTO Persons VALUES ('Jimmy','Jackson');
| INSERT ('Jimmy','Jackson'); INTO Persons;
| INSERT VALUES ('Jimmy','Jackson') INTO Persons;
|
|
'Olsen' 'LastName' 'Persons'.
| INSERT ('Olsen') INTO LastName FROM Persons
| INSERT INTO Persons ('Olsen') INTO LastName;
| INSERT INTO Persons (LastName) VALUES ('Olsen');
|
|
'Hansen' 'Nilsen' 'LastName' 'Persons'?
| UPDATE Persons SET LastName='Hansen'
INTO LastName = 'Nilsen';
| SAVE Persons SET LastName='Nilsen'
WHERE LastName ='Hansen';
| SAVE Persons SET LastName = 'Hansen'
INTO LastName = 'Nilsen';
| UPDATE Persons SET LastName='Nilsen'
WHERE LastName = 'Hansen';
|
|
"Persons' , FirstName 'Peter'?
| DELETE FirstName = 'Peter'
FROM Persons;
| DELETE ROW FirstName = 'Peter'
FROM Persons;
| DELETE FROM Persons
WHERE FirstName = 'Peter';
|
|
'Persons'?
| SELECT NUMBER
FROM Persons;
| SELECT COLUMNS
FROM Persons;
| SELECT COUNT(*)
FROM Persons;
| SELECT COUNT Persons;
|
|
:
SELECT * FROM Music, Tracks WHERE Music.Id=Tracks.Music_Id;
| SELECT *
FROM Music INNER JOIN Tracks ON Music.Id=Tracks.Music_Id;
| SELECT * FROM Music INNER JOIN Tracks IN Music.ID=Tracks.Music_Id;
| SELECT *
FROM Music INNER JOIN Music.Id ON Tracks = Tracks.Music_Id;
| SELECT *
FROM Music.Id INNER JOIN Tracks.Music_Id IN Tracks=Music;
|
|
"" , "_" 1990 . ( SQL Jet)
| SELECT , , _
FROM
WHERE _>=#06/01/1990# AND _<=#08/31/1990#;
| SELECT , , _
FROM
WHERE _ BETWEEN #06/01/1990# AND _<=#08/31/1990#;
| SELECT , , _
FROM
WHERE _ BETWEEN #06/01/1990# AND #08/31/1990#;
| SELECT , , _
FROM
WHERE _ IN (#06/01/1990#, #08/31/1990#);
|
|
, _, _, _ . SELECT , Avg(_), Avg(_), Avg(_)
FROM
GROUP BY ;
|
| GROUP BY
| ,
| _
|
|
c , _, _, _ .
| SELECT , Avg(_), Avg(_), Avg(_)
FROM
GROUP BY ;
| SELECT Avg(), Avg(_), Avg(_), Avg(_)
FROM
GROUP BY ;
| SELECT , Avg(_), Avg(_), Avg(_)
FROM
HAVING ;
| SELECT , Avg(_), Avg(_), Avg(_)
FROM
GROUP BY
HAVING =87
|
|
. : Smallint, _ Char(30), Char(5, _ Smallint, _ Real, _ Real, _ Real. :
SELECT *
FROM
WHERE _ BETWEEN 150 AND 250;
| , Char
| , Real
| , Smallint
|
|
|
. : Smallint, _ Char(30), Char(5, _ Smallint, _ Real, _ Real, _ Real. :
SELECT *
FROM
WHERE _ BETWEEN 150 AND 250;
|
| , _ 150 _ 250
| , _ 150 _ 250
| , _ 150 250, .
| , _ 150 250, .
|
|
:
CREATE TABLE ( Int, Char(15), Smallint, Char(15), _ Int, _ Smallint, _ Int);
?
| ,
| , Char
| ,
| ,
|
|
, . ?
| DROP TABLE ;
| DELETE FROM ; DROP TABLE ;
| SELECT DISTINCT ; DROP TABLE ;
| DELETE FROM ;
|
|
, . ?
| DROP TABLE ;
| DELETE FROM ; DROP TABLE ;
| SELECT DISTINCT ; DROP TABLE ;
| DELETE FROM ;
|
|
_, .
?
| DELETE FROM WHERE _ =Ĕ;
| SELECT DISTINCT _
FROM ;
| SELECT _
FROM ;
| DELETE FROM WHERE DISTINCT _
|
|
, _ _ Smallint. _
UPDATE SET _=[_]*[];
=150, _ = 3220?
| ,
| , Smallint.
| , . : UPDATE _ SET =[_]*[];
| , : UPDATE _ FROM WHERE _=_*;
|
|
: Smallint, _ Char(30), _ Smallint, _ Real, _ Real. :
SELECT *
FROM
WHERE _ IN ("","");
| , ,
| Char, ,
| Real, ,
| , ,
|
|
. ?
| CREATE TABLE (_ Int, Char(15),, _ Int, _ Smallint, _ Int);
| CREATE TABLE ( Int, Char(15), Int, Smallint, Int);
| CREATE TABLE (_ Int, Char(15), _ Int, _ Smallint, _ Int)
| CREATE AS TABLE ( Int, Char(15), Int, Smallint, Int);
|
|
:
SELECT COUNT *
FROM Tracks;
| , *
| , ,
| , * Tracks
| , GROUP BY
| , ORDER BY
|
|
:
SELECT Tracks_Music.Id, COUNT(N_Tracks)
FROM Tracks
ORDER BY Tracks_Music.Id
GROUP BY N_Tracks;
| , N_Tracks
| , GROUP BY ORDER BY
| , N_Tracks
| , Tracks_Music.Id N_Tracks
|
|
:
SELECT SUM(St_tov), Kod_tov
FROM Vedomost
GROUP BY 1 AND 2;
| , GROUP BY
| , GROUP BY AND
| , GROUP BY AND
| , GROUP BY ORDER BY
|
|
:
DELETE FROM Employee_Tbl
WHERE Emp_Id IN (SELECT Emp_Id
FROM Employee_Pay_Tbl);
| , Employee_Tbl, DELETE Employee_Pay_Tbl
| , Employee_Pay_Tbl, DELETE Employee_Tbl
| Emp_Id Employee_Tbl Employee_Pay_Tbl
| Employee_Tbl Employee_Pay_Tbl
|
|
:
SELECT Music_Id, N_Tracks
ORDER BY Tracks
FROM Tracks;
| ORDER BY GROUP BY.
| ORDER BY Music_Id FROM Tracks;
| ORDER BY FROM Tracks
| : FROM Tracks GROUP BY Music_Id, N_Tracks;
|
|
:
SELECT Music_Id, N_Tracks
FROM Tracks
WHERE Music_Id=345
ORDER BY 1;
|
|
| ORDER BY.
| WHERE HAVING
|
|
31654 31655
| UPDATE Kod_tov SET WHERE Kod_tov IN 31654 ON 31655;
| UPDATE Kod_tov SET =31655;
| UPDATE SET Kod_tov=31655 WHERE Kod_tov=31654;
| UPDATE Kod_tov SET =31655 WHERE Kod_tov=31654;
|
|
: Smallint, _ Char(30), Smallint, _ Smallint, _ Smallint.
_?
| UPDATE SET _=[_]*[];
| UPDATE _ SET =[_]*[];
| UPDATE _ SET WHERE _=[_]*[];
| UPDATE _ SET [_]*[] FROM ;
|
|
, ,
40% .
| UPDATE SET = []*1.4
WHERE ="";
| UPDATE WHERE =""
SET = []*1.4;
| UPDATE SET = []*40%
WHERE ="";
| UPDATE SET = []*40%
GROUP BY ();
|
|
40 _ '' '_
''.
| INSERT (40) INTO _ FROM ''
| INSERT INTO '' (' ') INTO '_ ;
| INSERT INTO (_, _) VALUES (40, '');
| INSERT INTO (40, '') VALUES (_, '_ )
|
|
_ Smallint, Char(25), Smallint
. 1 2
| UPDATE SET = 2
WHERE Like ;
| UPDATE SET = 2
WHERE Like *;
| UPDATE SET = 2
WHERE = ;
| UPDATE SET = ;
WHERE = 2
|
|
_, , _ , 10% Ĕ.
| UPDATE SET =1.1*
WHERE _="";
| UPDATE SET =10%*
WHERE _="";
| UPDATE SET =10%*
WHERE _="";
| UPDATE _ SET =10%*
WHERE _="";
|
|
: 2017-03-18; !; : 800 | :
:
, , . ==> ... 1991 - | 1643 -
© 2015-2024 lektsii.org - - |