Top "Where-clause" questions

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

SQL JOIN - WHERE clause vs. ON clause

After reading it, this is not a duplicate of Explicit vs Implicit SQL Joins. The answer may be related (or …

sql join where-clause on-clause
How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

Database: Sybase Advantage 11 On my quest to normalize data, I am trying to delete the results I get from this …

sql select where-clause advantage-database-server sql-delete
SELECTING with multiple WHERE conditions on same column

Ok, I think I might be overlooking something obvious/simple here... but I need to write a query that returns …

mysql sql aggregate-functions where-clause
Oracle date "Between" Query

I am using oracle database. i want to execute one query to check the data between two dates. NAME START_…

sql oracle oracle10g where-clause date-arithmetic
Left Join With Where Clause

I need to retrieve all default settings from the settings table but also grab the character setting if exists for …

sql left-join where-clause
What is the difference between HAVING and WHERE in SQL?

What is the difference between HAVING and WHERE in an SQL SELECT statement? EDIT: I have marked Steven's answer as …

sql where-clause having
SQL WHERE condition is not equal to?

Is it possible to negate a where clause? e.g. DELETE * FROM table WHERE id != 2;

mysql sql where-clause negate
Detect if value is number in MySQL

Is there a way to detect if a value is a number in a MySQL query? Such as SELECT * FROM …

mysql sql where-clause
MySQL join with where clause

I have two tables I want to join. I want all of the categories in the categories table and also …

mysql join where-clause
WHERE vs HAVING

Why do you need to place columns you create yourself (for example select 1 as "number") after HAVING and not WHERE …

mysql sql where-clause having-clause