Interested to Buy Any Domain ? << Click Here >> for more details...
one of the column in my table contains the data like
SAL
----
1000
1000
2000
3000
3000
So my requirement is i want output like
SAL
---
1000
2000
3000
it mean i want to delete duplicate rows in the table
permanently and i want output in the above formatow should u
write query?
- 13 Answers
- 23746 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / dinesh kumar
delete from table_name alias1
where rownum < ( select max(rownum) from table_name alias2
where alias1.col1 = alias.col2 );
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we delete column in sql?
Is mariadb nosql?
Difference between truncate, delete and drop commands?
What is pivot query?
Where is pl sql used?
What is flag in sql?
What is microsoft t sql?
How do you respond to dementia behavior?
How do I filter in sql profiler?
What is a database event trigger?
What is difference between group by and partition by?
Explain isolation levels. : Transact sql
what is the difference between nested subquery and correlated subquery?
Explain constraints in sql?
What are the benefits of pl sql?
