select aa.rownumber,aa.keyword from(
select ROW_NUMBER() OVER(ORDER BY id) AS rownumber,* from keyword) as aa where keyword='MD'
一条查询某一条数据是整个表中的第几条数据的SQL

select aa.rownumber,aa.keyword from(
select ROW_NUMBER() OVER(ORDER BY id) AS rownumber,* from keyword) as aa where keyword='MD'