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
- 23402 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
How to move files from one directory to another in pl sql?
what is the bond code in materialized view?
What is character functions?
Is sql an operating system?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Is left join same as join?
what are the 'mysql' command line arguments? : Sql dba
how do you know the version of your mysql server? : Sql dba
What is difference between mysql and postgresql?
Is sql developer case sensitive?
What are the types of keys?
what are the difference between clustered and a non-clustered index? : Sql dba
Name three sql operations that perform a sort.
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is audit logout in sql profiler?
