SQL查询-如何不包括一些结果 [英] SQL Query - How to not include some results

问题描述

很抱歉，在我无法正确形式化之前提出此问题。我在表中有一个代码列，想要查询它，但是要删除带有某些特定代码的某些元素。假设我想使用代码从4开始的元素，但不包括代码的第六个数字为9（1121290）的元素。

I apologize if this question was asked before I just couldn't correctly formalize it. I have a code column in a table and want to query it but remove some elements with some particular code. Say I want to take elements with code starting from 4 but not include the elements with code whose 6-th number is 9 (1121290).

代码列包含字符串最大长度为8个字符的数字。并且我想接受几乎所有以4开头的内容，除了以411、427和428开头的元素

The code column contains string of numbers with max-length of 8 char. and I want to take almost everything that starts with 4 except elements that start with 411, 427 and 428

推荐答案

是的这样的查询：-

我有6位数字代码的列元素。

I have column element with 6 digit codes.

我正在获取其元素第一个数字是4或第六个数字是9。

I am fetching element whose 1st digit is 4 or 6th is 9.

我们必须使用％和 _

we have to use % and _ for fetching..

SELECT element  FROM "table" WHERE element LIKE '%4____9%';

尝试它会起作用。

以4开头的所有内容，但以411、427和428开头的元素除外：-

Everything that starts with 4 except elements that start with 411, 427 and 428 :-

 SELECT element  FROM "table" WHERE element LIKE '%4__';

第一个数字是4，第六个数字不是9：我测试了这个数字，它工作正常，请尝试以下操作： -

1st digit is 4 and 6th is not 9: I tested this one it is working fine try this :-

SELECT element  
FROM "table" 
WHERE element NOT LIKE '%_____9' and element LIKE '%4_____'

这篇关于SQL查询-如何不包括一些结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！