write a query to delete similar records in same table
Answer Posted / apurva
delete from <tablename> rowid not in (select max(rowid)
from <tablename> group by <col.name where there are
repeating records>);
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are different types of queries in sql?
Where the sql database files are stored?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is the command used to fetch the first 5 characters of a string?
Do prepared statements prevent sql injection?
how many ways to get the current time? : Sql dba
what is transaction? : Sql dba
Why triggers are used?
What is the difference between sum and count in sql?
What is scalar and vector?
how to use in conditions? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is the sql case statement?
What will you get by the cursor attribute sql%found?
what are the t string functions available in tsql? : Transact sql