Top "Where-clause" questions

A syntactic form in functional languages used to bind a value to a name in a local scope.

SQL Filter criteria in join criteria or where clause which is more efficient

I have a relatively simple query joining two tables. The "Where" criteria can be expressed either in the join criteria …

sql sql-server join where-clause
Doctrine: Multiple (whereIn OR whereIn) query?

I'm having trouble crafting a fairly simple query with Doctrine... I have two arrays ($countries, $cities) and I need to …

symfony1 doctrine where-clause dql
How do you do a Rails 3 select IN using where clauses

I am using Rails 3 and I need to do a select where the primary key of the records is IN …

ruby-on-rails ruby-on-rails-3 where-clause
T-SQL Where Clause Case Statement Optimization (optional parameters to StoredProc)

I've been battling this one for a while now. I have a stored proc that takes in 3 parameters that are …

sql-server tsql query-optimization case where-clause
How can I have is null condition in typeorm find options?

In my queries I'm using typeorm find option, How can I have IS NULL condition in the where clause?

sql where-clause typeorm typeorm-activerecord
Oracle: How to do multiple counts with different where clauses the best way?

I have requirement to count rows with different where clauses from the same table. The following is the required output …

oracle count where-clause multiple-columns
Where clause to check against two columns in another table

I am struggling to get this answer for some reason. I have two tables, table1 and table2 which look like …

sql join where-clause where-in
How to build a WHERE-clause in a LiquiBase changeset

How do I have to define a changeset in 'LiquiBase' notation for updating a table column whith an AND-ed WHERE-clause: &…

where-clause liquibase changeset
How to include multiple conditions in a SELECT?

I am using 5 Parameters to fetch the details from DB table (mara, makt, marc, mard). PARAMETERS :number TYPE matnr MATCHCODE …

where-clause abap opensql sap-selection-screens
Sequelize - subquery in where clause

I'm using Sequelize in my Express app. I need to generate a query that has a subquery in the WHERE …

orm subquery where-clause sequelize.js