Чтобы обучить другого, требуется больше ума, чем чтобы научиться самому (М. Монтень).
SQL – Примеры операторов сравнения
(1 оценок, среднее: 5,00 из 5)
Загрузка...
|
1 |
SQL> SELECT * FROM CUSTOMERS; |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 1 | Maxim | 35 | Moscow | 21000.00 | | 2 | AndreyEx | 38 | Krasnodar | 55500.00 | | 3 | Oleg | 33 | Rostov | 34000.00 | | 4 | Masha | 35 | Moscow | 31500.00 | | 5 | Ruslan | 34 | Omsk | 43000.00 | | 6 | Dima | 32 | SP | 45000.00 | | 7 | Roma | 34 | SP | 10000.00 | +----+----------+-----+-----------+----------+ 7 rows in set (0.00 sec) |
Пример 1
|
1 |
SQL> SELECT * FROM CUSTOMERS WHERE SALARY > 45000; |
Вывод
|
1 2 3 4 5 6 |
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 2 | AndreyEx | 38 | Krasnodar | 55500.00 | +----+----------+-----+-----------+----------+ 1 rows in set (0.00 sec) |
Пример 2
|
1 |
SQL> SELECT * FROM CUSTOMERS WHERE SALARY = 55000; |
Вывод
|
1 2 3 4 5 6 |
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 2 | AndreyEx | 38 | Krasnodar | 55500.00 | +----+----------+-----+-----------+----------+ 1 rows in set (0.00 sec) |
Пример 3
|
1 |
SQL> SELECT * FROM CUSTOMERS WHERE SALARY != 55000; |
Вывод
|
1 2 3 4 5 6 7 8 9 10 11 |
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 1 | Maxim | 35 | Moscow | 21000.00 | | 3 | Oleg | 33 | Rostov | 34000.00 | | 4 | Masha | 35 | Moscow | 31500.00 | | 5 | Ruslan | 34 | Omsk | 43000.00 | | 6 | Dima | 32 | SP | 45000.00 | | 7 | Roma | 34 | SP | 10000.00 | +----+----------+-----+-----------+----------+ 6 rows in set (0.00 sec) |
Пример 4
|
1 |
SQL> SELECT * FROM CUSTOMERS WHERE SALARY <> 55000; |
Вывод
|
1 2 3 4 5 6 7 8 9 10 11 |
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 1 | Maxim | 35 | Moscow | 21000.00 | | 3 | Oleg | 33 | Rostov | 34000.00 | | 4 | Masha | 35 | Moscow | 31500.00 | | 5 | Ruslan | 34 | Omsk | 43000.00 | | 6 | Dima | 32 | SP | 45000.00 | | 7 | Roma | 34 | SP | 10000.00 | +----+----------+-----+-----------+----------+ 6 rows in set (0.00 sec) |
Пример 5
|
1 |
SQL> SELECT * FROM CUSTOMERS WHERE SALARY >= 4500; |
Вывод
|
1 2 3 4 5 6 7 |
+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 2 | AndreyEx | 38 | Krasnodar | 55500.00 | | 6 | Dima | 32 | SP | 45000.00 | +----+----------+-----+-----------+----------+ 2 rows in set (0.00 sec) |
