Query for Data redundancy

[brucepayne]

what is the query for reduce redundancy in table plz help me

[SkinHead]

What do you mean by redundancy ?

Do you mean records that are older than a specific date ?

[brucepayne]

What do you mean by redundancy ?

Do you mean records that are older than a specific date ?

i mean one table have data's with redundancy...i want write query for select data's without redundancy

[SkinHead]

My apologies for being thick, but by redundancy, do you mean duplicate records ?

Could you give a brief example from the table of records that are deemed redundant, then I can suggest a means of selecting them.

Cheers

[brucepayne]

yes i mean duplication of records ....when we write a query that omit all dublication records from table and display them into another new table without dublication

Cheers

[SkinHead]

There is some useful info on duplicate records in the following article.

http://www.kodyaz.com/articles/delete-duplicate-records-rows-in-a-table.aspx

I know it's to do with deleting duplicates, but it should give you some ideas.

[ck9663]

if it's a complete duplicate (meaning all columns are the same) you can simply include the keyword DISTINCT on your select

try:

select distinct * from tablename

[hariharanmca]

i mean one table have data's with redundancy...i want write query for select data's without redundancy

there is no word called data's, its data.