如何在sql中为多个条件获取单个输出 [英] how to get a single output for multiple condition in sql

问题描述

我的表格如下：

My table is look like this:

Sub_Package_ID       Package_ID           Destination_ID       Sub_Destionation_ID
-------------------- -------------------- -------------------- --------------------
1                    1                    1                    5
2                    1                    2                    8
3                    1                    2                    9
4                    2                    1                    6
5                    2                    2                    7
6                    3                    1                    5
7                    3                    2                    7
8                    4                    1                    5
9                    4                    2                    8
10                   4                    2                    9
11                   4                    2                    7

我想以这种方式编写查询，如果我输入（6,7），因为Sub_Destionation_ID查询将返回（2）as Package_ID，如果我输入（5,7）作为Sub_Destionation_ID查询将返回（3）作为Package_ID



如果根据用户输入不存在此类Package_ID，例如

如果我输入（6,9）作为Sub_Destionation_ID查询将不返回任何Package_ID，

如果我输入（8,5）因为Sub_Destionation_ID查询将不返回任何Package_ID，

如果我输入（8,9）作为Sub_Destionation_ID查询将不返回任何Package_ID，

如果我输入（8,7）作为Sub_Destionation_ID查询将不返回任何Package_ID。 br $> b $ b



希望我能解释一下我的问题;如果有任何疑问请询问。



请帮我解决这个问题。

提前致谢。

I want to write a query in that way if i enter (6,7) as Sub_Destionation_ID query will return (2) as Package_ID, if i enter (5,7) as Sub_Destionation_ID query will return (3) as Package_ID

if there is no such Package_ID exists as per user input such as
if i enter (6,9) as Sub_Destionation_ID query will return nothing as Package_ID,
if i enter (8,5) as Sub_Destionation_ID query will return nothing as Package_ID,
if i enter (8,9) as Sub_Destionation_ID query will return nothing as Package_ID,
if i enter (8,7) as Sub_Destionation_ID query will return nothing as Package_ID.


Hope i can explain my question; if there is any query please ask.

Please help me to solve this query.
Thanks in advance.

推荐答案

SELECT DISTINCT (Package_ID)FROM [Sub_Package]
WHERE Sub_Package.Package_ID In (select Package_ID from Sub_Package where Sub_Destionation_ID = '6')
    And Sub_Package.Package_ID In (select Package_ID from Sub_Package where Sub_Destionation_ID = '7')
    And Sub_Package.Package_ID In (select Package_ID from Sub_Package where Sub_Destionation_ID = '9')

这篇关于如何在sql中为多个条件获取单个输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！