如何返回表中找不到的ID [英] How to return the ids that not where found in a table

问题描述

你好.

我需要一个查询，在该查询中，我想举例说明在表中找不到的ID，例如

拥有表格收件箱
ID |名称|
---------------------
1 |杜德
2 |其他花花公子
3 |一些花花公子
4 |那家伙

如果我搜索ID 1,3,6,7,10，我希望查询返回6,7和10

有可能吗?查询将如何?

谢谢

Hello.

I need a query where i will want to egt the ids that not where found in a table for example

Having a table Inbox
Id | Name |
---------------------
1 | Dude
2 | Other Dude
3 | Some Dude
4 | That Dude

if i search for Ids 1,3,6,7,10 i will like my query to return 6,7 and 10

is it possible?, how would the query be?

Thanks

推荐答案

在此示例中，如何将1,3,6,7,10传递给查询?

您需要将这些值放入单独的表或某种虚拟函数驱动的表中.然后是这样的:

How are you passing in 1,3,6,7,10 to your query in this example?

You need to get those values into a seperate table, or some sort of virtual function driven table. Then its something like:

select id from <new table> where id not in (select id from <existing table>)

这篇关于如何返回表中找不到的ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！