相同的查询 只是查询的字段不同缺出现数据不一?为什么呢?
select top 12 id,
filetitle, iscopyright, isCommend, nickname, userid, addtime
from VIEW_VoxMusicList
order by visitcount ASC
select top 12 id
from VIEW_VoxMusicList order by visitcount ASC
这里两个查询只是字段的多少不一样
却出现了不一样的ID数据 为什么呢?
VIEW_VoxMusicList视图如下
SELECT dbo.VOX_MyMusic.id AS musicid, dbo.VOX_MyMusic.filetitle,
dbo.VOX_MyMusic.iscopyright, dbo.VOX_MyMusic.visitcount,
dbo.VOX_MyMusic.evaluate, dbo.VOX_MyMusic.isCommend,
dbo.VOX_User.nickname, dbo.VOX_MyMusic.userid,
dbo.VOX_MyMusic.addtime
FROM dbo.VOX_MyMusic INNER JOIN
dbo.VOX_User ON dbo.VOX_MyMusic.userid = dbo.VOX_User.id