abes_nitya Posted August 23, 2006 Share Posted August 23, 2006 Sir plz tell me "how to delete duplicate row from a table". thanks.bye..... Link to comment Share on other sites More sharing options...
Reg Edit Posted August 23, 2006 Share Posted August 23, 2006 Sir plz tell me "how to delete duplicate row from a table". thanks.bye.....Hmmm... there's no general answer to that I'm afraid! Can you be more specific? If you can describe your data, and state the rules that identify the row to be deleted, someone can probably help with the SQL statement. Also is this MS SQL Server, MySQL, MS Access or what? Link to comment Share on other sites More sharing options...
bhavik_solanki Posted September 16, 2006 Share Posted September 16, 2006 Sir plz tell me "how to delete duplicate row from a table". thanks.bye.....Delete From EmpSalary where EmpId In( Select A.EmpId From EmpSalary A,EmpSalary B Where A.EmpId > B.EmpId And A.Salary = B.Salary ) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now