Курс SQL Базы данных ORACLE. Урок 2-2. Операторы IN, LIKE, BETWEEN, работа с датами, работа с NULL
Prime Soft (Студия Прайм)
19,092 views
SQL. Databases. ORACLE. Lesson 2. Part 2. Simple Queries. IN, LIKE, BETWEEN Operators, Working with Dates, Multi-Level Sorting, Working with NULL.
The entire program is available at https://prime-soft.biz/courses/sql
Enroll in the course and receive unlimited access to all lessons, access to your personal test database for practicing your skills and completing independent practice problems. You'll also receive feedback on your work and advice on completed tasks.
11 Comments
from persons
where FilislID =1 or FilialID = 2
____________
Select *
From persons
where FilialID = 1 and birthday > to_date (' 01.01.1980 ', 'dd.mm.yyyy')
______________________-
select *
from persons
where Name like 'А%'
__________________-
select *
from canteendishes
where price between 70 and 100
order by price desk
_________________-
select *
from canteendishes
where cookid not like null
order by name
1) Я хочу найти всех людей, которые родились в октябре, и пишу запрос
where birthdate like to_date('%.10.%','dd.mm.yyyy')
Но у меня ошибка. where birthdate = '%.10.%' тоже не работает.
Как бы вы написали?
2) Я хочу сделать выборку записей, где поле имеет определенное значение либо пусто. Если не использовать OR, то получается:
where FilialName in ('Москва', null)
Однако он показывает только те записи, где есть "Москва", с пустым знаечением не выводит. Почему?
FROM person
1) WHERE filialid IN (1,2)
2) WHERE filialid = 1 AND birthdate >= to_date('01.01.1980', 'dd.mm.yyyy')
3) WHERE name LIKE 'A%'
SELECT *
FROM canteendishes
4) WHERE price between 70 AND 100
ORDER BY price desc
5) WHERE cookid IS NOT NULL
ORDER BY name
??
Курс SQL Базы данных ORACLE. Урок 2-2. Операторы IN, LIKE, BETWEEN, работа с датами, работа с NULL
Prime Soft (Студия Прайм)
19,092 views
SQL. Databases. ORACLE. Lesson 2. Part 2. Simple Queries. IN, LIKE, BETWEEN Operators, Working with Dates, Multi-Level Sorting, Working with NULL.
The entire program is available at https://prime-soft.biz/courses/sql
Enroll in the course and receive unlimited access to all lessons, access to your personal test database for practicing your skills and completing independent practice problems. You'll also receive feedback on your work and advice on completed tasks.