I have a table like this one.
I want to fetch those duplicate sl no whose status is M and N.
Means from the above I table i want follwing result
Plz help me.
This will return a count of the records duplicated.
answered May 28 '10 at 04:34 AM
answered May 28 '10 at 05:18 AM
Kev Riley ♦♦
Yes the Query Work........
/* we have to use the Self join between the table... we have to get the duplicate record and and name as Table Alis and then use self join...*/
select Distinct test.id, test.stat from test join
answered May 28 '10 at 06:39 AM