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笔资料,并以某资料栏位大小来排序