相同的Sql查询结果在2个数据库中显示不同的结果 [英] Same Sql query result is showing different result in 2 databases

问题描述

我在一个日期库中使用SQL查询。结果显示在这里很好。但是，当我使用相同的查询在另一个数据库中获取相同的数据时，它显示数据重复。





SELECT distinct ROW_NUMBER（） OVER（ORDER BY r.Name）作为SrNo，r.Place，rb.Address，r.PetName FROM tblA AS OW INNER JOIN tblB AS r INNER JOIN tblD AS on ON r.StatusId = s.StatusId INNER JOIN tblE AS rb ON r.tId = rb.tId ON OW.Id = r.Id INNER JOIN tblLookupWard AS LW INNER JOIN tblLookupLocation AS L ON LW.Id = L.Id INNER JOIN tblLookupCity AS city ON LW.Id = city.Id ON r.Id = L.Id

I am using a SQL query in one datebase. The result is showing fine here. But when i use the same query for fetching the same data in another Database it showing duplication in data.


SELECT distinct ROW_NUMBER() OVER (ORDER BY r.Name) As SrNo, r.Place,rb.Address, r.PetName FROM tblA AS OW INNER JOIN tblB AS r INNER JOIN tblD AS s ON r.StatusId = s.StatusId INNER JOIN tblE AS rb ON r.tId = rb.tId ON OW.Id = r.Id INNER JOIN tblLookupWard AS LW INNER JOIN tblLookupLocation AS L ON LW.Id = L.Id INNER JOIN tblLookupCity AS city ON LW.Id = city.Id ON r.Id = L.Id

推荐答案

由于下面的代码，您获得了重复的版权，因为您在另一个数据库中有重复的数据。作为你的查询你有重复的r.Name，但它有不同的SrNo ...所以它显示你有不同的SrNo重复行..



ROW_NUMBER（）超过（按r.Name排序）作为SrNo



谢谢

如果你从中找到了一些帮助，然后把它作为解决方案并投票给它。

Hemant Singh

Due to below code you getting duplicate vlaues, because you having duplicate data in another database. As your query you have duplicate r.Name but having different SrNo for it... so that it shows you duplicate row with having different SrNo..

ROW_NUMBER() OVER (ORDER BY r.Name) As SrNo

Thanks
If you find some help from it then plz mark as solution and vote it.
Hemant Singh

这篇关于相同的Sql查询结果在2个数据库中显示不同的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！