-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: TilakArora
Message 1 in Discussion
hi everybody
i have few problem plz help me
......
1. how to delete a duplicate
records from a table in sql server 2000 using single query.
i have a
table(Table1) with two fields:A,B
A
B
1
a
2
b
3
c
2
b
1
a
4
d
using single
query i have to delete
2. using single query i have to
insert a record which also check for dupliacy
&
ony if there is no duplicate record
then it should insert.
3. i have a table with two
fields:BankName & AccountHolder
BankName AccountHolder
a1 x1
a1 y1
a1 z1
b1 x1
b1
z1
c1 x1
c1
y1
c1
z1
c1
w1
i have to
find out Bank Name with Second Maximum Account Holders.
thanks
-----------------------------------------------------------
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]
