[an error occurred while processing this directive]

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

 

 

 

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class  varchar(10))

Insert data into Stu_Table

insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',10);
insert into Stu_Table values(4,'Bhanu',10);
insert into Stu_Table values(5,'Santosh',10);
insert into Stu_Table values(1,'Komal',11);

Stu_Table

Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10
1 Komal 11

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 : 

SELECT columnName(s)
FROM tableName
where condition1 AND conditions2

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. 

SELECT Stu_Id, Stu_Name, Stu_Class
FROM Stu_Table
where Stu_Id = 1 AND Stu_name = 'komal'

Result

Stu_Id Stu_Name Stu_Class
1 Komal 10
1 Komal 11

                         

[an error occurred while processing this directive]