SQL如下:
sSQLQuery = "SELECT TOP 30 mineral_id, mineral_no, mineral_ch_name, mineral_en_name, origin_place, reserve_amount, mineral_sort, mineral_remark FROM (SELECT TOP 60 * FROM mineral_info WHERE mineral_sort=4 ORDER BY mineral_id DESC) ORDER BY mineral_id"; sSQLQuery = "SELECT TOP 30 mineral_id
sSQLQuery = "SELECT TOP 30 mineral_id, mineral_no, mineral_ch_name, mineral_en_name, origin_place, reserve_amount, mineral_sort, mineral_remark FROM (SELECT TOP 60 * FROM mineral_info WHERE mineral_sort=4 ORDER BY mineral_id DESC) ORDER BY mineral_id"; sSQLQuery = "SELECT TOP 30 mineral_id