SQL And Statement

sql and statement

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_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'


Stu_Id Stu_Name Stu_Class
1 Komal 10
1 Komal 11


Share on Google+Share on Google+

SQL And Statement

Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: SQL And Statement  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image