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 only how should u
write query?
Answer Posted / hiya
select n from (select row_number()over (partition by n order
by n) r,n from test group by n having count(*)>1)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is schema in sql?
Where do we use pl sql?
How to use boolean type in select statement?
What is a call statement? Explain with an example.
What is trigger and types?
What is raw datatype in sql?
Is inner join faster than left join?
How can you load multi line records? : aql loader
What is an inconsistent dependency?
Why self join is used in sql?
Is it possible to create startup or shutdown trigger for on-schema?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What are the disadvantages of file system?
explain mysql aggregate functions. : Sql dba