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
- 23674 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 is difference between inner join and cross join?
What is pl sql package?
Are sql connections encrypted?
what are sequences
what's the difference between a primary key and a unique key? : Sql dba
When sql appeared?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are two statement types in sql?
Why are sql stored procedures used?
Explain unique key in sql.
Explain about various levels of constraint.
What is difference between pl and sql?
What is the main difference between sql and pl/sql?
Do prepared statements prevent sql injection?
What is case function?
