Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 25116 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / balaji
delete from sampletable where ids in(select ids from
sampletable group by ids having count(ids)>1)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What can sql server reporting services do?
what is sql profiler? : Sql dba
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
how are mysql timestamps seen to a user? : Sql dba
What is the process of copying data from table a to table b?
What is the size of partition table?
What are transaction and its controls?
How do I write a sql query in pgadmin 4?
Explain the insert into statements in sql?
What is the difference between microsoft access and sql?
What is the largest value that can be stored in a byte data field?
who introduced sql?
how to use regular expression in pattern match conditions? : Sql dba
How do I save the results of sql query in a file?
