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'
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.