从相同的ID获取最后的详细信息 [英] getting last details from same ID
本文介绍了从相同的ID获取最后的详细信息的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嘿..
我有一个查询,其中获得两个结果为相同的ID ..我想获得相同ID的第二个结果..
Hey..
I have a query ,in that Getting Two result as Same Id ..I want to get second result of same id ..
Name Id
----------------
A 1
B 2
C 3
D 3
E 4
F 4
在此,我想要同样ID的第二个结果如
IN this , I want the second result of same Id like
Name Id
---------------
A 1
B 2
D 3
F 4
是否有任何查询可以这样......
Is there is any query to get like this .....
推荐答案
从表格中选择* ID(从表中选择前1个ID,其中ID = 3,按NAME desc排序)
如果不是解决粘贴你查询我们可以提供帮助。
我已经创建了演示就像你的查询一样参考:
这是我的桌子和他们的fie lds
select * from Table where ID in (select top 1 ID from Table where ID=3 order by NAME desc)
If you not solve paste you query we can help on that.
I have create Demo As like your query refer this:
This are my tables and their fields
UnitTypes:
UnitTypeID(int) UnitTypeName(varchar)
Units:
UnitID(int) UnitTypeID(int) UnitName(varchar)
Products:
ProductID(int) ProductName(varchar) UnitID(int) UnitTypeID(int)
这是查询解决方案:
This is query for you solution:
select Distinct UT.UnitTypeID,UT.UnitTypeName,U.UnitID,U.UnitName,P.ProductID,P.ProductName,P.UnitId from UnitTypes UT
inner join Units U on U.UnitTypeID=UT.UnitTypeID
inner join Products P on P.UnitId=U.UnitID and P.ProductID in (select MAX(ProductID) from Products where p.UnitId=UnitID)
order by U.UnitID
接受答案并投票即可解决您的问题。
Accept as answer and vote is solve your problem.
如果您的姓名的排序是升序,如果可以使用Max()获取最后的细节
If your Name's sorting is ascending, if can use Max() to get the last detail
Select * from yourTable where (id, name) = any (select id, Max(name) from yourTable)
这篇关于从相同的ID获取最后的详细信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文