sql select where in code example

Example 1: where clause in sql

Where clause basically returns only 
true conditions

Select First_Name
From Customers
Where ID = 1905Cimbom;

Example 2: select in select sql

SELECT column-names  FROM table-name1 WHERE value IN (SELECT column-name                   FROM table-name2                   WHERE condition)

Example 3: where query in sql server

SELECT * FROM Customers
WHERE Country='Mexico';

Tags:

Sql Example

Related