Posted by Simon Hayes on 09/14/05 18:06

Here's one option:

select
t.Contact,
t.Company,
t.Job_Title,
t.Importance
from
dbo.MyTable t
join
(
select Company, max(Importance) as 'Importance'
from dbo.MyTable
) dt
on t.Company = dt.Company
and t.Importance = dt.Importance

Simon

• Next in forum: Re: oracle pl/sql -> sql server
• Prev in forum: Re: oracle pl/sql -> sql server
• Thread view: Re: Help on a SQL query

[Reply to this message]