Sunday, May 19, 2019


WHERE Clause




Where clause used to filter data or records from database.

The WHERE clause is used to extract only those data or records, which fulfill a specified condition.
Syntax :

SELECT column1, column2,column3, . . . FROM table_name WHERE condition;

Example :

SELECT C_City FROM Customer01 WHERE C_Id = 1;

In above example, we are using equal sign.

The WHERE Clause Conditional selections used in the where clause are:

=
Equal
>
Greater than
<
Less than
>=
Greater than or equal
<=
Less than or equal
<>
Not equal to
                               Note: In some versions of SQL this operator may be written as !=
BETWEEN
Between a certain range
LIKE
Search for a pattern
IN TO
Specify multiple possible values for a column


Latest
Next Post

post written by:

0 Comments: