结合两个mysql查询

问题描述

我有两个 sql 查询...

I have two sql queries...

set  @count:=0;
select @count:=@count+1 as SNO, col1, col2 FROM table;

我想将上述查询合并为一个查询.有什么帮助吗?

I want to combine above queries into a single query. Any Help?

推荐答案

你可以这样做，

select @count:=@count+1 as SNO, col1, col2
FROM table, (SELECT @count:=0) r ;

就像为每一行添加RowNumber一样

Just like adding RowNumber for each row

select @rownum:=@rownum+1 ‘rank’,
       p.*
from player p, (SELECT @rownum:=0) r
order by score
desc limit 10;

在 MySQL 中添加 RowNumber

这篇关于结合两个mysql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！