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
- 23226 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / suneelkumar
delete from emp x where rowid>(select rowid from emp y where
x.sal=y.sal)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to include numeric values in sql statements? : Sql dba
How do I restart sql?
Explain the difference between triggers and constraints?
What is row_number () in sql?
How do I remove sql plus from windows 10?
Explain the difference in execution of triggers and stored procedures?
What are procedures used for?
what is auto increment? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is an intersect?
What is the use of sqlerrd 3?
Is grant a ddl statement?
how would you enter characters as hex numbers? : Sql dba
Do we need to rebuild index after truncate?
what are aggregate and scalar functions? : Sql dba
