i have a table SBTRAN i have to select distinct rows of that table in which it should elminate the duplicate rows depending on the accno that is ACCNO should be unique
my table has the collumns that look like below
SB_TYPE ACCNO NAME ACC_TYPE GENDER ADDRESS PINCODE
i should get the distinct rows in which ACCNO should not have duplicate valuesother collumns can have duplicate values.
please help me out thanks in advance
View Complete Post