摘要:
三个关键词:Index,Row_number()和 limit select * from (select row_number() over( order by huiyuan.vip desc,huiyuan.time ) as orderid, count(1) over() as n_cou 阅读全文
摘要:
案例:返回结果集中的前十二条数据 使用关键字 limit select hy.id,hy.domain,c.com_name,hy.time from huiyuan hy INNER JOIN com c ON c.cust_id=hy.id and c.com_kind='物流公司' where 阅读全文