where sql code example

Example 1: sql selet

SELECT *
FROM table
WHERE condition
GROUP BY expression
HAVING condition
{ UNION | INTERSECT | EXCEPT }
ORDER BY expression
LIMIT count
OFFSET start

Example 2: sql not equal

<>	Not equal. Note: In some versions of SQL this operator may be written as !=

Example sql query:

1) Selecting groceries where price is not 20
SELECT * FROM Grocery WHERE Price <> 20;

Example 3: where keyword sql

Where clause basically returns only 
true conditions

Select First_Name
From Customers
Where ID = 1905Cimbom;

Example 4: sql select syntax

select [all/distinct] <COL1>, <COL2>, <COL3>
from <TABLE_NAME>
[join <JOIN_CONDITION>]
[where <CONDITION>]
[group by <COLUMN_NAME>]
[having <SEARCH_CONDITION>]
[order by <SORT_SPECIFICATION>]


/*
Specifically for SQL -> Oracle

LEGEND: 
[...]   :   optional entries
<...>   :   your specific entry
*/

Example 5: sql or

Used alongside WHERE to include data when either condition is true.
Example: Returns users that live in either Sheffield or Manchester.
SELECT * FROM users
WHERE city = 'Sheffield' OR 'Manchester';

Example 6: sql where multiple values

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);