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
What is a dirty read sql?
Is sql the best database?
What is trigger explain it?
Does view store data in sql?
What is difference between left and right outer join?
What is the left table in sql?
What are the constraints available in sql?
What is a sql select statement?
how to fetch alternate records from a table? : Sql dba
what is online transaction processing (oltp)? : Sql dba
What is bitemporal narrowing?
What is difference between procedure and trigger?
What are the different ways to optimize a sql query?
What are different types of tables in sql?
what are sequences