Hi,
Is there any way by which we can just get non duplicate records from a file by deleting all the duplicate records and just able to show only last last record based on RRN which is the last record in those all duplicate records.
Can all this be achieved in a single SQL statement, if yes then what should be that Sql query?
Thanks.
Is there any way by which we can just get non duplicate records from a file by deleting all the duplicate records and just able to show only last last record based on RRN which is the last record in those all duplicate records.
Can all this be achieved in a single SQL statement, if yes then what should be that Sql query?
Thanks.
Comment