programplug Logo




And Clause



The And Clause is used to join or create two or more conditions to be met.
It is used in SQL statement like SELECT,INSERT,UPDATE and DELETE statements.

Syntax:

SELECT columns1, coloumn2,coloumn3,...coloumnN  
FROM table_name
WHERE condition 1  
AND condition 2
AND condition3...
AND conditionN;
	
Example:
Teacher
c_id c_name c_age c_experience
01 Baithy 37 7
02 Lennin 27 2
03 Shaun 41 6
04 Peter 29 3
05 Mike 44 8
	   
SELECT * from Teacher
WHERE age>30 AND experience>5;
It would produce the following output:
c_id c_name c_age c_experience
01 Baithy 37 7
03 Shaun 41 6
05 Mike 44 8





Our Services

Developing Cheapest Websites
Offer Digital Marketing
Provide College Projects
Attractive Website Developing
Summer Training,Industrial Training
SCO,SMO

Contact Us

Dehradun Uttarakhand India
www.programplug.com
info@programplug.com
08534019974
Designed By : Mridul Gupta

Other Link

About Us

Contact Us

Disclaimer

Privacy Policy