Query for Data redundancy

what is the query for reduce redundancy in table plz help meWhat do you mean by redundancy ?

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

Quote:

Originally Posted by SkinHead

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|||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|||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|||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.|||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|||

Quote:

Originally Posted by brucepayne

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.