从相同的ID获取最后的详细信息 [英] getting last details from same 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屋！