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
- 23350 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 difference between primary and secondary key?
What is primary key and foreign key with example?
How do I truncate a word?
Explain the difference between sql and mysql.
how to include character strings in sql statements? : Sql dba
How to set up sql*plus output format in oracle?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
describe mysql connection using mysql binary. : Sql dba
How do you remove duplicate records from a table?
How many types of primary keys are there?
What is microsoft t sql?
What is the difference between the conventional and direct path loader? : aql loader
what is msql? : Sql dba
Can there be 2 primary keys in a table?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
