Total members 11890 |It is currently Sat Apr 20, 2024 3:17 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





To find a records with specific column value that is inside a specific range you can use the BETWEEN SQL command like this :

Code:

SELECT * FROM 'Department' WHERE NumOfStudents BETWEEN 60 and 150




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

Author: DrRakha
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  Page 1 of 1
  [ 1 post ] 

  Related Posts  to : BETWEEN SQL COMMAND
 SQL LIKE query Command     -  
 SQL LOCATE command     -  
 Calling the man Command     -  
 SQL GROUP BY Command     -  
 SQL ALTER Command     -  
 SQL DISTINCT Command     -  
 Average SQL command     -  
 PHP echo command     -  
 SQL COUNT Command     -  
 JVM does not recognize MQ command.     -  



Switch to mobile style
cron




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