<div>
<pre><code id="code-20-37069466-1">Select Name, City, Country from tableName where Country not like 'USA' or City like 'New York City'</code></pre>
</div>


Select Name, City, Country from tableName where Country not like 'USA' or City like 'New York City'

<div>
Why use 'like' when an equality check will do?<br />
<br />
'like' is for wildcard use. &nbsp;It will work but might mess with the optimizer.
</div>


Why use 'like' when an equality check will do?

'like' is for wildcard use.  It will work but might mess with the optimizer.

<div>
So if you have the line John, New York City, USA.<br />
<br />
Does this line get included because it is in New York or does it get excluded because it in the USA<br />
<br />
Sorry for the beginnner-level question. I am pretty new to SQL
</div>


So if you have the line John, New York City, USA.

Does this line get included because it is in New York or does it get excluded because it in the USA

Sorry for the beginnner-level question. I am pretty new to SQL

<div>
yes, the record will be seen in the output
</div>


yes, the record will be seen in the output

<div>
yep, LIKE will be little slower<br />
because the wildcards requires additional processing
</div>


yep, LIKE will be little slower
because the wildcards requires additional processing

<div>
<div class="content wysiwyg-content">
I have a question about a select query.<br />
I have a table with three columns (NAME, CITY, COUNTRY)<br />
I would like to select all rows except the USA, But I would like to include New York City.<br />
<br />
How can I do this in one select query?<br />
<br />

</div>
</div>


I have a question about a select query.
I have a table with three columns (NAME, CITY, COUNTRY)
I would like to select all rows except the USA, But I would like to include New York City.

How can I do this in one select query?



Sql select query

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.