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.
