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

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

Related Tags for SQL AND Statement:
sql,  c,  io,  filter,  sed,  display,  operator,  opera,  show,  condition,  record,  records,  to,  base,  sh,  bot,  e,  il,  it,  spl,  use,  pe,  first,  as,  conditions,  play,  tr,  isp,  based,  true,  ase,  how,  tor,  when,  s,  sp,  at,  is,  ir,  and,  rds,  s,  s,  rd,  th,  sho,  cond,  st,  disp,  pl,  nd,  on,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization

Ask Questions?    Discuss: SQL AND Statement  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):