SQL AND Operators
The AND operator displays records if both conditions are true.
Understand with Example
The Tutorial illustrates an example from SQL AND Operator. In this Tutorial, Table Stu_Table is created using create table statement. The insert into statement is used to add records or rows to the table Stu_Table. The Select statement show you the list of records from a table Stu_Table.
Create Table Stu_Table
Insert data into Stu_Table
SQL AND Operator Syntax
The SQL AND Operator Syntax return you the filter record from a table based upon the condition specified in the query.
SQL AND Operator Query
The given SQL Query help you to select only the Stu_Table with the Stu_Id equal to"1" AND Stu_class="10".The AND operator fetch the records from a table, if both the condition are to be true. In case, any one of the condition is false, fetch no records from table.