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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / destiny
create table salary2 as select distinct * from salary1
drop table salary1
rename salary2 to salary1
Is This Answer Correct ? | 0 Yes | 0 No |
what is a trigger? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What are the two parts of a procedure ?
Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
What is the difference between row level and statement level trigger?
What does pragma mean?
What is dba in sql? : SQL DBA
How many postgresql users are there, worldwide?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
What is memory optimized?
What is the default isolation level in sql server? : Transact sql
what is the stuff function and how does it differ from the replace function? : Sql dba