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);
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'
We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.
Posted on: December 20, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles