select aa.rownumber,aa.keyword from(
select ROW_NUMBER() OVER(ORDER BY id) AS rownumber,* from keyword) as aa where keyword='MD'
一条查询某一条数据是整个表中的第几条数据的SQL
最新推荐文章于 2022-04-13 11:18:50 发布
select aa.rownumber,aa.keyword from(
select ROW_NUMBER() OVER(ORDER BY id) AS rownumber,* from keyword) as aa where keyword='MD'