Details

    Description

      This is already available in MariaDB as "EXCEPT"

      returns the Result of the query 1 that is not found in the result of query 2

      MariaDB [world]> select * From City where id between 456 and 457 except select * from City where id=456;
      +-----+------------+-------------+----------+------------+
      | ID  | Name       | CountryCode | District | Population |
      +-----+------------+-------------+----------+------------+
      | 457 | Birmingham | GBR         | England  |    1013000 |
      +-----+------------+-------------+----------+------------+
      

      Oracle Doc: https://www.techonthenet.com/oracle/minus.php

      Attachments

        Activity

          People

            monty Michael Widenius
            Faisal Faisal Saeed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.