Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql SQL AND Statement

Related Tutorials


 
 

Share on Google+Share on Google+

SQL AND Statement

Advertisement
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.

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
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 20, 2008

Related Tutorials

Discuss: SQL AND Statement  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com