I think the correct answer should be -

select * from (select lname , datemodified , ROW_NUMBER() over (PARTITION by lname,jobtitle order by datemodified desc) as 'ct' from #DuplicateRow) a where...

Thanks every one!!! ...

Thanks every one for your support.

i got 3 methods to do that.

1. To make temp table with i will check with my real time DB and is the easiest method.

2....

Ya we were there before also. Thanks for your help.Actually i am new to this and trying to catch thing quickly.Here you go.....

create table info (id int,name text,class varchar(50))

insert into...

Thanks a lot guys for your support...........I am getting the required result now.

Cheers,

Preetpal:-)

The result that i want is:

Prod id quantity

p2 11

p3 16

This is...