sql-between..and

"栏位名" FROM " 表格名" WHERE "栏位名" BETWEEN ‘ 值一 ‘ AND ‘ 值二 ‘ ;

 

这将选出栏位值包含在值一及值二之间的每一笔资料。

举例来说，若我们要由  Store_Information  表格中找出所有介于 January 6, 1999 及 January 10, 1999 中的资料

 

 SELECT   *  
 FROM   Store_Information 
  WHERE  Txn_Date  BETWEEN   ‘  Jan-06-1999  ‘   AND   ‘  Jan-10-1999  ‘ ;

结果:

   Store_Name    Sales    Txn_Date  
San Diego      250      07  - Jan -  1999  
San Francisco      300      08  - Jan -  1999  
Boston      700      08  - Jan -  1999 

 

sql-between..and

标签：

查看更多关于sql-between..and的详细内容...