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
- 23722 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / narasimha
select distinct(sal) sal from salex;
| Is This Answer Correct ? | 35 Yes | 22 No |
Post New Answer View All Answers
What is a constraint? Tell me about its various levels.
Why do we create stored procedures & functions in pl/sql and how are they different?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is the difference between delete, truncate and drop command?
How do I clear the screen in sql plus?
How to rename a column in the output of sql query?
How do I access sql anywhere database?
Write a sql query to get the third highest salary of an employee from employee_table?
What is primary key and foreign key with example?
What is meant by cursor in sql?
what is log shipping? : Sql dba
What is difference between sql function and stored procedure?
How do I view a sql trace file?
Why procedure is used in sql?
What is pl sql code?
