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?
Answer Posted / yaswanth
select salary from emp where rowid NOT IN(select max(rowid) from emp GROUP BY salary);
Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
How many functions are there in sql?
What are different types of functions in sql?
What is data control language (dcl)?
Why do you partition data?
How do I find sql profiler?
What is count * in sql?
What is dml and ddl?
What does closing a cursor do?
Can ddl statements be used in pl/sql?
Why is the cursor important?
what is offset-fetch filter in tsql? : Transact sql
How do I audit the sql sent to the server?
Why triggers are used?
What is the use of sqlerrd 3?
what is a database? : Sql dba