Interested to Buy Any Domain ? << Click Here >> for more details...
how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 14173 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / shekharjchandra
I think people here just answering the questions just for sake of answering. First of all the framing of question is not correct, anyone who knows oracle will know how to delete records from table, just by using Delete from tablename...etc etc
By looking into the question and example by Sophia it looks like she wants to delete the duplicate rows from the table.
Some of you answered correctly like Pratap.
But others are just telling the difference between Delete and Truncate, which is not required in this context at all, I am sure if we answer like this in interviews the interviewer will decide what he wants.
Please don't mind my words, and take it serious and give to the prompt answers, even if u dont know correct answer try to get from other sites, so that when someone looks for such questions they should get correct answer rather they should read all answers for getting correct reply.
Regards
J
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the 'mysql' command line arguments? : Sql dba
What is difference between procedure and trigger?
What is sql profiling in oracle?
Does truncate need commit?
What is a ddl command?
Explain the advantages and disadvantages of stored procedure?
What is optimistic concurrency control? : Transact sql
what are the advantages of mysql in comparison to oracle? : Sql dba
What is crud sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is a relationship and what are they?
What is indexing oracle sql?
Is left join inner or outer by default?
What are the popular database management systems in the it industry?
what is the difference between a local and a global temporary table? : Sql dba
