1、select * from table order by 字段 desc这是按此字段的降序排.2、select * from table order by 字段 asc这是按升序排.3、举个例子：Public Sub SortX()Dim cnn As New ADODB.ConnectionDim rst As New ADODB.Recordsetrst.CursorLocation = adUseClientcnn.Open "DSN=Pubs;Provider=MSDASQL;uid=sa;pwd=;"rst.Open "SELECT * FROM Authors", cnn, _
...
