Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Answers were Sorted based on User's Feedback



how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / kriahna chaitanya

delete From <table>;

Is This Answer Correct ?    22 Yes 4 No

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / chinna

truncate table <tbl_nm>

Is This Answer Correct ?    14 Yes 7 No

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / hannan oca

delete from tablename; will remove all records but we can
rollback these values.

truncate tablename; will remove all records but we cannot
rollback the table values if we want that values in future.

Is This Answer Correct ?    2 Yes 0 No

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / 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

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / pratap

delete from table name;
or truncate table name;

Is This Answer Correct ?    5 Yes 4 No

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / rupesh

Mr. Krishna Kumar


With truncate rows will delete as well as tablespace not.


instead of tablespace you have to use physical memory space.

Is This Answer Correct ?    0 Yes 0 No

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / krishna kum ar

delete <table_name> --------This removes only the records
not a tablespace

but

truncate <table_name>--------This removes both records as
well as tablespaces in database

Is This Answer Correct ?    2 Yes 3 No

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c..

Answer / 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



More SQL PLSQL Interview Questions

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,


What is pl sql commands?

0 Answers  


what does the t-sql command ident_current does? : Transact sql

0 Answers  


what is check constraint? : Sql dba

0 Answers  


What is pl/sql table? Why is it used?

0 Answers  






Which are the most commonly used sql joins?

0 Answers  


Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,


What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  


how many triggers are allowed in mysql table? : Sql dba

0 Answers  


What is sql in oracle?

0 Answers  


What is sqlservr exe?

0 Answers  


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  






Categories