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 / suma

can we use group by?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of pl/sql table?

546


what are the advantages and disadvantages of views in a database? : Sql dba

526


How do you update f as m and m as f from the below table testtable?

1060


Is sql an operating system?

540


What is oracle and pl sql?

656






explain what is mysql? : Sql dba

590


What is the source code of a program?

501


What are the operators in sql?

520


What is full form of rtm?

525


What is use of term?

614


What is localdb mssqllocaldb?

608


How to take user input in pl sql?

696


how to calculate expressions with sql statements? : Sql dba

523


Explain what is table in a database?

569


How do I view a sql database?

551