SQL Basic- SQL WHERE Condition ~ Beginner School

SQL WHERE Condition:

SQL WHERE Condition is used to filter records.

This condition is show only those record as per specified in where condition.

Syntax:

SELECT column_name
FROM table_name

WHERE column_name operator value;

Table: 'Student'

StudentID	StudentName	Address	Country
1	Ajay	Noida	India
2	Ajeet	Bareilly	India
3	Shivam	Nagaland	India

Example:

SELECT *

FROM Student

WHERE Address ='Bareilly';

Text Value vs. Numeric Value:

In SQL text values definition requires single quotes around (most database systems will also allow double quotes).
Numeric value definition not required.

After executing this statement, it result is

StudentID	StudentName	Address	Country
2	Ajeet	Bareilly	India

About Admin

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Beginner School

SQL Basic- SQL WHERE Condition