Questions tagged [where-clause]

15

votes

2

answers

MySQL - Where Or?

mysql sql where-clause

asked 2013-07-30T17:29:12.463

124

votes

6

answers

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

sql select where-clause advantage-database-server sql-delete

asked 2013-07-09T12:56:30.283

10

votes

1

answers

ActiveRecord test Greater/Lesser Than inside Hash Condition

activerecord hash compare conditional-statements where-clause

asked 2013-05-17T13:02:10.580

20

votes

2

answers

Dynamic where clause (OR) in Linq to Entities

c# linq entity-framework linq-to-entities where-clause

asked 2013-01-31T08:34:13.110

12

votes

2

answers

Conditional where clause in JPA criteria query

jpa where-clause predicate criteria-api conditional-statements

asked 2012-12-31T05:05:31.187

57

votes

1

answers

How to use numpy.where with logical operators

python numpy where-clause logical-operators

asked 2012-11-27T17:10:18.703

30

votes

8

answers

MySQL WHERE <multiple-column> IN <subquery>

mysql where-clause multiple-tables in-subquery

asked 2012-07-09T10:41:13.587

41

votes

6

answers

SQL Server : check if variable is Empty or NULL for WHERE clause

sql sql-server if-statement where-clause

asked 2012-04-23T16:09:17.867

57

votes

8

answers

WHERE clause before INNER JOIN

mysql join optimization where-clause

asked 2012-04-12T23:39:35.260

8

votes

9

answers

mysql - if value = 0 shorten where statement

php mysql where-clause

asked 2012-04-10T14:18:52.713

21

votes

8

answers

How to implement a BETWEEN condition in a WHERE clause with CodeIgniter active record

php codeigniter activerecord where-clause between

asked 2012-03-30T10:48:32.143

18

votes

2

answers

What is the Big O of linq .where?

c# linq big-o where-clause

asked 2012-03-25T22:47:50.217

18

votes

2

answers

In Haskell, what is the scope of a where clause when dealing with guards?

haskell scope pattern-matching where-clause

asked 2012-03-15T14:03:59.497

20

votes

9

answers

SQL Server: Multiple table joins with a WHERE clause

sql-server join where-clause

asked 2012-01-06T13:04:26.700

29

votes

6

answers

What's the difference between "where" clause and "on" clause when table left join?

sql where-clause on-clause

asked 2011-11-29T12:58:07.803

11

votes

1

answers

Will Postgres push down a WHERE clause into a VIEW with a Window Function (Aggregate)?

postgresql where-clause window-functions

asked 2011-09-23T19:30:37.943

11

votes

3

answers

Q (kdb): nested where query

sql where-clause kdb+ inner-query

asked 2011-07-17T18:19:21.367

17

votes

3

answers

Postgres array lookup in WHERE clause

arrays postgresql where-clause

asked 2011-03-30T19:57:38.017

61

votes

4

answers

How to write a not equal condition using CodeIgniter's where() method?

php codeigniter activerecord where-clause query-builder

asked 2011-03-07T22:53:08.203

9

votes

4

answers

Rails: Why can't you set an association to nil in a where clause?

ruby-on-rails ruby-on-rails-3 activerecord where-clause

asked 2011-03-05T21:32:09.923

231

votes

15

answers

Detect if value is number in MySQL

mysql sql where-clause

asked 2011-02-21T10:44:29.397

263

votes

7

answers

Left Join With Where Clause

sql left-join where-clause

asked 2011-01-20T20:52:47.713

35

votes

4

answers

T-SQL Conditional WHERE Clause

sql sql-server t-sql where-clause case-statement

asked 2010-12-20T00:27:15.477

11

votes

3

answers

LINQ WHERE with OR

c# linq where-clause

asked 2010-11-09T16:38:09.967

31

votes

2

answers

MySQL: how to index an "OR" clause

mysql indexing composite where-clause

asked 2010-05-13T19:09:47.403

11

votes

7

answers

Is it poor practice to build an SQL query using WHERE 1=1 AND

php sql where-clause

asked 2010-04-12T15:42:01.850

43

votes

5

answers

C# FindAll VS Where Speed

c# performance where-clause findall

asked 2010-02-14T05:23:58.057

23

votes

5

answers

It's possible to have a WHERE clause after a HAVING clause?

sql where-clause having

asked 2009-11-04T06:15:43.063

173

votes

10

answers

SQL : BETWEEN vs <= and >=

sql sql-server t-sql where-clause between

asked 2009-10-27T11:38:15.320

10

votes

3

answers

LINQ results when there are no matches?

c# linq where-clause

asked 2009-10-07T17:48:17.783

166

votes

3

answers

MySQL join with where clause

mysql join where-clause

asked 2009-08-02T21:31:55.307

74

votes

10

answers

Is a JOIN faster than a WHERE?

sql performance join where-clause

asked 2009-07-15T07:31:29.223

70

votes

9

answers

Dynamic WHERE clause in LINQ

c# linq dynamic where-clause

asked 2009-05-11T14:34:42.963

22

votes

6

answers

Execution order of conditions in SQL 'where' clause

sql oracle-database where-clause

asked 2008-12-04T10:26:10.973

19

votes

5

answers

In SQL how to compare date values?

sql mysql compare where-clause

asked 2008-11-25T19:25:41.370

Questions tagged where-clause