Popular "in-clause" questions | Page 3

Oracle - In CLAUSE question when using with multiple values, making it dynamic

I just spent an hour on google and here trying to get a straight answer for how to do this …

oracle in-clause

I'm very unfamiliar with Oracle and am just trying to get this to work. I've looked here and here but …

oracle parameters in-clause

CASE Statement in where clause using equal to and IN

WHERE CONDITION1='ABC' AND Status = CASE @Option WHEN 1 THEN 'True' WHEN 2 THEN 'False' WHEN 3 THEN NULL WHEn 4 THEN **IN ('True', …

sql sql-server-2008 case-statement in-clause

Sql IN clause slows down performance

I need a help about sql query performance... I have a view and when I run view as select * from …

sql sql-server performance in-clause

Combine 'like' and 'in' in a SqlServer Reporting Services query?

The following doesn't work, but something like this is what I'm looking for. select * from Products where Description like (@SearchedDescription + %) …

reporting-services sql-like in-clause

give parameter(list or array) to in operator - python, sql

I have a list in python. article_ids = [1,2,3,4,5,6] I need to use this list in sql statement like this : SELECT …

python sql parameters in-clause

SQL In Clause Multiple Columns

SELECT * FROM Tabl tabb WHERE (tabb.col1, tabb.col2) IN ( (1,2), (3,4)) The above works in Oracle but I am trying to …

sql multiple-columns in-clause in-operator

MySQL specifying exact order with WHERE `id` IN (...)

Is there an easy way to order MySQL results respectively by WHERE id IN (...) clause? Example: SELECT * FROM articles WHERE …

mysql sql-order-by in-clause

find the missing values from a set of values, using SQL

How can I find a missing values from a set of values, using SQL (Oracle DB) e.g. SELECT NAME …

sql oracle in-clause

Making MySQL IN Clause Case Sensitive

Does anyone know how I can make an IN clause behave in a case sensitive manner? I have seen that …

mysql sql case-sensitive in-clause string-search

Top "In-clause" questions