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

Why truncate is faster than delete?

1159

What is meant by cursor in sql?

1061

What are the built in functions of sql?

1092

What is java sql connection?

1120

Write a sql query to convert all character to uppercase after hypen.

1484

What is difference between sql and mysql?

1192

What does <> sql mean?

1166

what are the types of subquery? : Sql dba

1158

How many sql databases can you have on one server?

1152

What are string functions in sql?

1303

Write a sql query to find the names of employees that begin with ‘a’?

1057

What is a pl/sql block?

1326

how many sql dml commands are supported by 'mysql'? : Sql dba

1164

Give the order of sql select?

1185

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1162