SQL AND OR in WHERE query Commands

You can add OR AND to set combinations and more than one condition in the WHERE clause statement

For AND :
This query will display records with number of students larger than 100 and type is equal Major.

Code:

SELECT * FROM Department WHERE DeptType='Major' AND numOfStudents >100

For OR:
This query will display records with number of students larger than 100 or type is equal Major.

Code:

SELECT * FROM Department WHERE DeptType='Major' OR numOfStudents >100

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : SQL AND OR in WHERE query Commands
FTP commands -
jar files commands -
DELETE Commands -
Graphics commands list in C++ -
Execute System Commands -
EJB-QL IN where query -
update query example -
using parameter with name query -
Run query and search from ASP -
more than one parameter with name query -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com