getting last details from same ID

Question

0.00/5 (No votes)

See more:

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

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 .....

Posted 2-Jul-13 21:01pm

aravindnass

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thanh_bkhn · Accepted Answer · 2013-07-03T17:36:00

Solution 2

If your Name's sorting is ascending, if can use Max() to get the last detail

SQL

Select * from yourTable where (id, name) = any (select id, Max(name) from yourTable)

Posted 3-Jul-13 17:36pm

thanh_bkhn

jaideepsinh · Accepted Answer · 2013-07-02T21:25:00

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

SQL

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:

SQL

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.