select >
top

select top 100 records

選取前100筆資料

select top 100 from a table and order by a field

資料表中選取前100筆資料

example 1:
<%
SQL= "select top 100 * from table_name order by field_name "
%>

example 2:
selsect top 100 and order by text time form 
<%
"select top 100 * from table_name order by cast(text_time as datetime) DESC"
%>

範例1:
由一資料表中選取前100筆資料

範例2:
由一資料表中選取前100筆資料,並以某資料欄位大小來排序