Мужчина, который умно говорит о любви, не очень любит (Ж. Санд).
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) |
