Top "Where" questions

Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail

In this candidate answer it is asserted that JOIN is better than LEFT JOIN under some circumstances involving some WHERE …

sql postgresql join left-join where

ISNULL(value, 0) in WHERE clause MYSQL

I have this requets: SELECT sc.no, scl.quantite, scl.description, scl.poids, scl.prix, sl_ref.refsl, sl_ref.…

mysql where isnull

mysql fix Using where;

My SQL Query: SELECT * FROM updates_cats WHERE uid =118697835834 ORDER BY created_date ASC Current Indexes: index1(uid, created_date) …

mysql sql indexing query-optimization where

MySQL: how to index an "OR" clause

I'm executing the following query SELECT COUNT(*) FROM table WHERE field1='value' AND (field2 >= 1000 OR field3 >= 2000) There is …

mysql indexing composite where

Rails "find_all_by" vs ".where"

I have the following code: def maturities InfoItem.find_all_by_work_order(self.work_order).map(&:maturity) end …

ruby-on-rails where dynamic-finders

How to use ObjectQuery with Where filter separated by OR clause

Could somebody help me to answer how to rewrite raw SQL filter WHERE (...) OR (...) with ObjectQuery bilder, please? String queryRaw = "…

c# sql filter where objectquery

How can you turn an index array into a mask array in Numpy?

Is it possible to convert an array of indices to an array of ones and zeros, given the range? i.…

python arrays numpy where mask

where rownum=1 query taking time in Oracle

I am trying to execute a query like select * from tableName where rownum=1 This query is basically to fetch the …

oracle optimization where rownum

Invalid column name error in WHERE clause, column selected with CASE

I have a (rather complicated) SQL statement where I select data from lots of different tables, and to cope with …

sql-server tsql case where calculated-columns

Difference between filtering queries in JOIN and WHERE?

In SQL I am trying to filter results based on an ID and wondering if there is any logical difference …

sql join where resultset