Posted by Mark Probert on 02/22/07 00:21

Hi ..

I am geeting myself into many knots around how to do thsi extraction.

There is a table that contains the following:

aID bID cID dID
--------------------------
6 9 28 1
6 2 28 2
6 11 28 3
6 1 27 5
6 9 27 5
6 11 27 5

I am trying to get a result of:

aID bID cID dID
--------------------------
6 9 28 1
6 2 28 2
6 11 28 3
6 1 27 5

So, something like "the set off all values over bID which have the
greatest cID". Any ideas?

Many thanks, in advance,

--
-mark.

• Next in forum: Re: T-SQL for the following?
• Prev in forum: Re: Unicode characters (Japanese)
• Thread view: T-SQL for the following?

[Reply to this message]