how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 12567 Views
- Oracle, I also Faced
- E-Mail Answers
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 does it mean to have quoted_identifier on? : Sql dba
What is difference between pl and sql?
What is blind sql injection?
What are sql data types?
What is the difference between functions, procedures, and packages in pl/sql?
Can we perform dml in function?
Explain autonomous transaction.
What is case function?
What is on delete restrict?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is varchar example?
How can I change database name in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How can we store rows in PL/SQL using array?
What are field types?
