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
- 21794 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / abin
Select sal from (Select *,ROW_NUMBER() over (partition by
sal order by sal asc)num from emp) a
Where num=1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is secondary key?
what are the different functions in sorting an array? : Sql dba
Why should I use postgresql?
what are myisam tables? : Sql dba
Is sql scripting language?
What are the types of sql commands?
How do you run a query?
how many sql dml commands are supported by 'mysql'? : Sql dba
what is datawarehouse? : Sql dba
How to start the command-line sql*plus?
What is trigger in sql? Explain
What are all different types of collation sensitivity?
What is cte sql?
What is consistency?
What is sql table?
