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 only how should u
write query?
Answer Posted / yaswanth
select distinct(SAL) as SAL from table_name;
Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What do you mean by stored procedures?
What is a Mapplet?
explain mysql aggregate functions. : Sql dba
What program will open a mdb file?
How to sort the rows in sql.
Can we create clustered index without primary key?
Which is the correct statement about truncate and delete?
What are sql built in functions?
What is embedded sql what are its advantages?
How can we store rows in PL/SQL using array?
Can we use the cursor's to create the collection in PL/SQL?
how to extract a unit value from a date and time? : Sql dba
Is the primary key an index?
What is a relationship and what are they?
What is sql and its types?