|
,
GROUP BY
| HAVING
| ORDER BY
| LIMIT
| INTO
| WHERE
| VALUES
| SHOW
| SELECT
| Insert
|
|
| [46] , name stud
INSERT INTO stud (name) VALUES ("Melissa Jones")
| SELECT name, city FROM stud
| SELECT * FROM stud
| SELECT * FROM name
| SELECT name FROM stud
| SELECT stud FROM name
| SHOW name
| DESCRIBE name FROM stud
|
| [47] , 3-
SELECT name, adress FROM stud
| SELECT name, adress FROM stud WHERE avg_mark>3.5
| SELECT name, adress FROM stud WHERE fuculty=3
| SELECT name, adress FROM stud WHERE (avg_mark>3.5)OR(fuculty=3)
| SELECT name, adress FROM stud WHERE (avg_mark>3.5)AND(fuculty=3)
| SELECT name, adress FROM stud WHERE (avg_mark<3.5)AND(fuculty=3)
| SELECT name, adress FROM stud WHERE (avg_mark>3.5)AND(fuculty<3)
| SELECT name, adress FROM stud HAVING (avg_mark>3.5)OR(fuculty=3)
| SELECT name, adress FROM stud HAVING (avg_mark<3.5)AND(fuculty=3)
| SELECT name, adress FROM stud HAVING (avg_mark>3.5)AND(fuculty<3)
|
|
| [48] , 3-
SELECT name, adress FROM stud
| SELECT name, adress FROM stud WHERE avg_mark>3.5
| SELECT name, adress FROM stud WHERE fuculty=3
| SELECT name, adress FROM stud WHERE (avg_mark>3.5)OR(fuculty=3)
| SELECT name, adress FROM stud WHERE (avg_mark>3.5)AND(fuculty=3)
| SELECT name, adress FROM stud WHERE (avg_mark<3.5)OR(fuculty=3)
| SELECT name, adress FROM stud WHERE (avg_mark>3.5)AND(fuculty<3)
| SELECT name, adress FROM stud HAVING (avg_mark>3.5)OR(fuculty=3)
| SELECT name, adress FROM stud HAVING (avg_mark<3.5)AND(fuculty=3)
| SELECT name, adress FROM stud HAVING (avg_mark>3.5)AND(fuculty<3)
|
|
|
: 2015-05-06; !; : 784 | :
:
, . ==> ... 1627 - | 1389 -
© 2015-2024 lektsii.org - - |