access追加前五條記錄 access創(chuàng)建一個(gè)查詢,查詢年齡最小的前五條記錄?
access創(chuàng)建一個(gè)查詢,查詢年齡最小的前五條記錄?SQL=“select field name top5from table name where conditional order by fiel
access創(chuàng)建一個(gè)查詢,查詢年齡最小的前五條記錄?
SQL=“select field name top5from table name where conditional order by field name desc(SEC)”以上段落的意思是選擇表中符合where條件的相應(yīng)字段的前五條記錄,并根據(jù)字段名(orderby)按升序或降序排列。如果要選擇前五條記錄的所有字段,請(qǐng)將其更改為SQL=“select*top5from table name where conditional order by field name desc(SEC)”