Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?

Question Posted / suma

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 are hotfixes and patches?

889

What is nosql vs sql?

1123

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1116

What is constant in pl sql?

969

What are inner and outer joins examples of both?

880

What is the best free sql database?

1001

What is the maximum number of rows in sql table?

957

What is the difference between distinct and unique in sql?

875

What is trigger and types?

968

How do I run a sql trace?

908

Show the two pl/sql cursor exceptions.

1110

What is prepared statement in sql?

997

how can I make a script that can be bi-language (supports english, german)? : Sql dba

945

If a cursor is open, how can we find in a pl/sql block?

1105

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1021