469,646 Members | 1,567 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,646 developers. It's quick & easy.

Query for Data redundancy

what is the query for reduce redundancy in table plz help me
Jul 11 '07 #1
7 2875
What do you mean by redundancy ?

Do you mean records that are older than a specific date ?
Jul 11 '07 #2
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
Jul 11 '07 #3
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
Jul 11 '07 #4
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
Jul 11 '07 #5
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.
Jul 11 '07 #6
ck9663
2,878 Expert 2GB
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
Jul 12 '07 #7
hariharanmca
1,977 1GB
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.
Jul 12 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Riley DeWiley | last post: by
6 posts views Thread by srinivas | last post: by
4 posts views Thread by frizzle | last post: by
3 posts views Thread by maffonso | last post: by
1 post views Thread by csgraham74 | last post: by
18 posts views Thread by cov | last post: by
11 posts views Thread by sinner | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.