Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 19167 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / arif jameel
First add an Identity Column in table
Alter table <tblname>
Add < New_columnID > int identity(1,1)
Delete from <tblname> where < New_columnID> in
(select max(New_columnID)from <tblname>
Group by <tbl_columnname>
having count (<tbl_columnname>)>1)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is data profiling in sql?
Difference between truncate, delete and drop commands?
What is pl sql package?
How do I view a table in sql?
Is sql port 1433 encrypted?
What are the packages in pl sql?
What are user defined functions?
how to shutdown mysql server? : Sql dba
how to create a new table in mysql? : Sql dba
What are the advantages of sql?
What is the difference between inner join and outer join?
What is sql in java?
Which query operators in sql is used for pattern matching?
How delete all records from table in sql?
How do you create an update query?
