Total members 11889 |It is currently Fri Mar 29, 2024 3:32 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka






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:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 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     -  
 select query example in php     -  
 SQL LIKE query Command     -  
 Query about jsp and printer     -  
 insert query example     -  










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