Write articleAsk a questionTake the testShare code
m
mihamuzMarch 14, 2019, 3:19 p.m.

Выборка данных

PostgreSQL

Доброй ночи.
Есть таблица table

x | y

2 | 4

3 | 5

2 | 6

Как из нее вытащить все значения при условии x != 2 AND y != 4

СУБД PostgreSQL.

Вот так:

select * FROM table WHERE x != 2 AND y != 4

Возвращает только x = 3 y = 5

We recommend hosting TIMEWEB
We recommend hosting TIMEWEB
Stable hosting, on which the social network EVILEG is located. For projects on Django we recommend VDS hosting.

Do you like it? Share on social networks!

612
3
0
0
0
3
Evgenii Legotckoi
  • March 14, 2019, 5:57 p.m.

Добрый день.

Если я правильно понял, то запрос должен выглядеть так. 

select * from x_and_y where not (x='2' and y='4');
    0
    1
    0
    m
    • March 15, 2019, 3:39 p.m.
    • The answer was marked as a solution.

    Как я не догодался?) Спасибо

      0
      1
      0
      m
      • March 15, 2019, 3:41 p.m.

      Сори догадался)

        0
        1
        0

        Comments

        Only authorized users can post comments.
        Please, Log in or Sign up
        Last passed testsRating
        AD

        C ++ - Test 004. Pointers, Arrays and Loops

        • Result:50points,
        • Rating points-4
        m

        C ++ - Test 004. Pointers, Arrays and Loops

        • Result:80points,
        • Rating points4
        m

        C ++ - Test 004. Pointers, Arrays and Loops

        • Result:20points,
        • Rating points-10
        Last comments
        i
        innorwallNov. 15, 2024, 2:30 p.m.
        Qt/C++ - Lesson 065. The correspondence of HTTP errors to server response errors in QNetworkAccessManager s Midsummer Classic in Kansas City priligy online pharmacy
        i
        innorwallNov. 15, 2024, 1:44 p.m.
        Qt/C++ - Lesson 039. How to paint stroke in QSqlTableModel by value in the column? Many OPKs would advise users to start using the test strips around day 9 of your cycle, considering day 1 to be the first day of full menstrual flow buy priligy australia
        i
        innorwallNov. 15, 2024, 10:27 a.m.
        Release of C++/Qt and QML application deployment utility CQtDeployer v1.4.0 (Binary Box) optionally substituted alkoxy, optionally substituted alkenyloxy, optionally substituted alkynyloxy, optionally substituted aryloxy, OCH, OC H, OC H, OC H, OC H, OC H, OC H, O C CH, OCH CH OH, O…
        i
        innorwallNov. 15, 2024, 5:26 a.m.
        Qt/C++ - Lesson 031. QCustomPlot – The build of charts with time buy generic priligy We can just chat, and we will not lose too much time anyway
        i
        innorwallNov. 15, 2024, 3:03 a.m.
        Qt/C++ - Lesson 060. Configuring the appearance of the application in runtime I didnt have an issue work colors priligy dapoxetine 60mg revia cost uk August 3, 2022 Reply
        Now discuss on the forum
        t
        tonypeachey1Nov. 15, 2024, 2:04 p.m.
        google domain [url=https://google.com/]domain[/url] domain [http://www.example.com link title]
        i
        innorwallNov. 15, 2024, 1:50 p.m.
        добавить qlineseries в функции priligy for sale Gently flush using an ear syringe
        i
        innorwallNov. 11, 2024, 6:55 p.m.
        Всё ещё разбираюсь с кешем. priligy walgreens levitra dulcolax carbs The third ring was found to be made up of ultra relativistic electrons, which are also present in both the outer and inner rings
        IscanderChe
        IscanderCheOct. 31, 2024, 10:43 p.m.
        Не запускается программа на Qt: точка входа в процедуру не найдена в библиотеке DLL Попробуйте прогу CQtDeployer
        9
        9AnonimOct. 25, 2024, 4:10 p.m.
        Машина тьюринга // Начальное состояние 0 0, ,<,1 // Переход в состояние 1 при пустом символе 0,0,>,0 // Остаемся в состоянии 0, двигаясь вправо при встрече 0 0,1,>…

        Follow us in social networks