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

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> Databases >> SQL PLSQL

Question

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

Question Submitted By :: Sophia

Rank

Answer Posted By

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

Answer
# 1

delete From <table>;

Is This Answer Correct ?

12 Yes

3 No

Kriahna Chaitanya

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

Answer
# 2

truncate table <tbl_nm>

Is This Answer Correct ?

8 Yes

3 No

Chinna

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

Answer
# 3

Delete from table name where row_id not in (select min(no)
from table_name group by no)

Is This Answer Correct ?

2 Yes

4 No

Pratap

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

Answer
# 4

delete from table name;
or truncate table name;

Is This Answer Correct ?

2 Yes

2 No

Pratap

Question	Asked @	Answers
Other SQL PLSQL Interview Questions


how to create a database in oracle?		2
Give the structure of the function ?		1
What is the Subquery?		2
Give which cursor is better for better performance means type of cursors?		1
Does SQL*Plus contains pl/sql Engine?	TCS	1
if i perform any operation on views such as insert, delete etc will my base table get affected?????		3
how do u call in & out parameters for stored procedures?	A1-Technology	7
what is meant by forward declaration in functions?		2
What is a self join ?	BirlaSoft	5
Types of joins ?	Digital-GlobalSoft	3
If a View on a single base table is manipulated will the changes be reflected on the base table?		3
Explain UNION,MINUS,UNION ALL, INTERSECT?		1
how to create object in plsql	TCS	1
When we give SELECT * FROM EMP; How does oracle respond?	Accenture	14
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?	IBM	7
How do you handle exceptions. Give the syntax for it?	Microsoft	1
What is the basic structure of PL/SQL ?		4
what is oracle sql,pl/sql with interfaces	TCS	1
define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.		2
What is an index and types of indexes. How many number of indexes can be used per table ?	BirlaSoft	4

For more SQL PLSQL Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com