how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / pratap
Delete from table name where row_id not in (select min(no)
from table_name group by no)
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is keys and its types?
what is the difference between join and union? : Sql dba
What is the unique index?
Explain aggregate functions are available there in sql?
What is the difference between alter trigger and drop trigger statements?
What is mutating trigger?
Can we enter data in a table in design view?
how to create a table index in mysql? : Sql dba
Explain the difference between 'between' & 'and' operators in sql
What is record type in pl sql?
What is the difference between delete and truncate commands?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Is delete faster than truncate?
Can I create table without primary key?
How many clustered indexes can be created on a table?