Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 23669 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
how many groups of data types? : Sql dba
Does a primary key have to be a number?
which operator is used in query for pattern matching? : Sql dba
i have some prob lem to tell me about my self in interview first round ...
How do I write a sql query in pgadmin 4?
Why is theta join required?
what is denormalization. : Sql dba
How do you change a value in sql?
What is pl/sql table? Why is it used?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what is the difference between char_length and length? : Sql dba
List the various privileges that a user can grant to another user?
How do you update a table in sql?
How to get each name only once from an employee table?
What is pl sql quora?
