SELECT other columns except rn
FROM
(
SELECT ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Field1 DESC) AS rn,*
FROM Table
)t
WHERE rn=1

quote:

---

Originally posted by karthick.amace

Hi bros,

I need to compare the next row with the previous row of same table and produce nonidentical column.
for eg... say
mytable has

Row 1 => karthick 120 150 180
Row 2 => karthick 150 150 180

it want to gve output 150 of second row.
Plz suggest me...

---

SELECT DISTINCT Column1, Column2  
FROM   MyTable A, 
       MyTable B 
WHERE  A.id = B.id 
       A.Value > b.Value 

quote:

---

Originally posted by revdnrdy

quote:

---

Originally posted by karthick.amace

Hi bros,

I need to compare the next row with the previous row of same table and produce nonidentical column.
for eg... say
mytable has

Row 1 => karthick 120 150 180
Row 2 => karthick 150 150 180

it want to gve output 150 of second row.
Plz suggest me...

---

Is there a reason you couldn't just use a self join? Then you can compare rows to see which one meets your criteria (max value I guess since 150 is what you want in your example).

SELECT DISTINCT Column1, Column2  
FROM   MyTable A, 
       MyTable B 
WHERE  A.id = B.id 
       A.Value > b.Value 

Something like that? I don't understand what 'produce non-identical column' means but you can define that in the SELECT.

r&r

---