“<>"是什么意思?在甲骨文中的意思 [英] What does "<>" mean in Oracle

问题描述

<>在SQL语言中是什么意思:示例代码如下

What does <> mean in SQL language: Sample code is as follows

SELECT ordid,
       prodid,
       qty
FROM   item
WHERE  prodid IN (SELECT prodid
                  FROM   item
                  WHERE  ordid = 605)
       AND qty IN (SELECT qty
                   FROM   item
                   WHERE  ordid = 605)
       AND ordid <> 605;  

推荐答案

表示不等于".因此，您要过滤掉ordid为605的记录.总的来说，您正在寻找与分配给ordid 605的那些具有相同prodid和qty值的记录，但它们的顺序不同

It means 'not equal to'. So you're filtering out records where ordid is 605. Overall you're looking for any records which have the same prodid and qty values as those assigned to ordid 605, but which are for a different order.

这篇关于“&lt;&gt;"是什么意思?在甲骨文中的意思的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！