摘要：
最近將MYSQL查詢改成MSSQL關於查詢限制條件記錄於下：MYSQL1select*from[table]where... LIMIT 123MSSQL1selecttop123*from[table]where...--限制資料筆數(只取前面0~123筆)--(方法A)效率較好1selecttop123 *2from[user]3orderbyemp_iddesc--(方法B)效率較差1select*2from(selectROW_NUMBER() over (orderbyemp_idasc) rownum,3*4from[user] )asyourselect5whererownumb 阅读全文
