SQL AND Statement
The SQL AND operator is used to show you the filter records based upon conditions. The AND operator display you a record when both the first and second condition is true.
Understand with Example
The Tutorial illustrates an example from SQL AND Statement. In this Tutorial first we create a Table 'Stu_Table' using create table keywords. Now we insert a values in to table records or rows . The insert into keywords helps you to add records or rows into table Stu_Table. The Select return you the records or row from table Stu_Table.
Create Table Stu_Table
Insert data into Stu_Table
SQL AND Operator Syntax
The SQL AND Operator Syntax return you a filter records or rows from a table based on condition. The Syntax used for SQL AND Operator is given as :
SQL AND Operator Query
The given SQL Query uses SQL AND Operator to fetch the record from table 'Stu_Table' based upon where clause, which restricts the records from table based upon the AND operator condition. The AND operator query return you a record only ,if the both condition specified in query are true. Otherwise, no records fetch from a table.