3wt.ezer.com:SQL:select :學習 asp sql html code 繁體中文 w3 Learning

你正在閱覽 :: 繁體中文 Chinese_Traditional

學習.主題:

SiteMap

3w....學習.教學 > SQL > select »

w3 learning

SQL

Select

:: SUM
More detial or script code example

get sum of a field

取得某欄的合計值

Description:

select sum(field name) as anotherName from table where ....

sql="select sum(欄名) as 别名 from 桌表 where 條件"
set rs=conn.excute(sql)
用 rs("别名") 
合計值

SQL

Select

:: top
More detial or script code example

select top 100 records

選取前100筆資料

Description:

select top 100 from a table and order by a field

資料表中選取前100筆資料

...

[ 8/20/2008 ]

www learning school add more scripts and tips memo

You are at >>3WT.EZER.COM >> 3WT.EZER.COM/SQL/SELECT/INDEX.ASP>>SQL
Helpful link:: SEO web tools :: Live PR | SERP checker