sql 查询有多少行


select * ,ROW_NUMBER() OVER (order by id desc) as RowNumber,
COUNT(1) OVER() AS recordCount from() temp

posted @ 2020-09-02 11:46  wonderfulviews  阅读(922)  评论(0)  编辑  收藏  举报