-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: thajeer
Message 3 in Discussion
if only a read is required here is what
you can do .
select
A,B,C,D from tablename group by A,B,C,D having count(*) > 0
let me know if you meant something else
Thajeer Thundiyil
"shri" <[EMAIL PROTECTED]>
05/25/2004 06:23 PM
Please respond to
"BDOTNET" <[EMAIL PROTECTED]>
To
"BDOTNET" <[EMAIL PROTECTED]>
cc
Subject
Re: sql
New Message on BDOTNET
sql
Reply
Reply
to Sender Recommend
Message 2 in Discussion
From:
shri
Hi,
Usaully in such scenarios you will have to use a temporary
table and insert the data for all disctinct rows. Then delete all the rows
from the main table and insert the distinct rows back from the temporary
table.
Hope I have answered your query.
Regards,
shri
View
other groups in this category.
Also on MSN:
Start
Chatting |
Listen
to Music |
House
& Home |
Try
Online Dating |
Daily
Horoscopes
To stop getting this e-mail, or change how often it arrives, go to your
E-mail
Settings.
Need help? If you've forgotten your password, please go to Passport
Member Services.
For other questions or feedback, go to our Contact
Us page.
If you do not want to receive future e-mail from this MSN group, or if
you received this message by mistake, please click the "Remove"
link below. On the pre-addressed e-mail message that opens, simply click
"Send". Your e-mail address will be deleted from this group's
mailing list.
Remove
my e-mail address from BDOTNET.
ForwardSourceID:NT0000685A
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
