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
- 19751 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / priya
select DISTINCT sal from emp;
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What are the two types of exceptions in pl/sql?
How delete all data from table in sql?
What is use of trigger?
What is trigger and types?
Explain how can you save or place your msg in a table?
how to use like conditions? : Sql dba
What is assignment operator in pl sql?
Why do we use procedures in sql?
What are the three forms of normalization?
Is left join faster than inner join?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Is null operator in sql?
How many sql commands are there?
Explain mutating table error.
What are the operators in sql?
