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

define sql update statement ? : Sql dba

1121

What is field delimiter?

1048

What is cte sql?

994

What is scalar and vector?

1002

What is sap sql anywhere?

1078

Is it possible to create startup or shutdown trigger for on-schema?

1029

What is a null value?

1143

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

Can we alter stored procedure?

987

what is the command used to fetch first 5 characters of the string? : Sql dba

1638

How to create your own reports in sql developer?

1019

How to rename a column in the output of sql query?

1072

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2489

Is pl sql still used?

976

what are the drivers in mysql? : Sql dba

1021