Home >Database >Mysql Tutorial >在查询结果中添加一列表示记录的行数的sql语句
在查询结果中添加一列表示记录的行数的sql语句
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 17:57:212115browse
如何在查询结果中添加一列表示记录的行数？ 要求是增加一列显示行数
代码如下:
DECLARE @table TABLE ([Values] varchar(10))
Insert INTO @table Select 'AAA'
UNION ALL Select 'CCC'
UNION ALL Select 'EEE'
UNION ALL Select 'DDD'
UNION ALL Select 'BBB'
Select [RowID] = IDENTITY (int, 1, 1), * INTO # FROM @table
Select * FROM #
Drop TABLE #
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：用SQL语句实现随机查询数据并不显示错误数据的方法Next article：sql server不存在 sql server拒绝访问第1/3页