sql 一對多查詢:sql一對多關聯查詢[朗讀]

intpagecount=15(每頁顯示的行數)inttotalcount=30(頁數*每頁顯示的行數),這裡是第二頁stringsearchstring=xxxxxx(搜索條件)selecttoppagecount*from表名whereidnotin(selecttoptotalcountidfrom表名wheresearchstring)wheresearchstringorderbytimedesc然後下個aspnetpage的分頁控制項就行了,以上是分頁的sql語句。