What is DELECT.. Was that supposed to be SELECT??
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of krishan kant
chamoli
Sent: Monday, September 12, 2005 12:34 AM
To: [email protected]
Subject: Re: [AspNetAnyQuestionIsOk] sql query problem!!!
Hi,
Suppose I have a table Tbl_Temp with following fields (Vouch_Code int
identity,vouch_num, vouch_Date). Further consider that I have to delete
the voucher with duplicate voucher number i.e. Vouch_Num.
So Duplicate record will be found if one row/column value repeat more
the one time (depends on requirement).Here in above query I have to
check duplicate voucher number. So query will be
DELECT FROM Tbl_Temp WHERE Vouch_Code IN ( SELECT Vouch_Code FROM
Tbl_Temp Group BY Vouch_Num HAVING COUNT(Vouch_Num) > 1)
KK
manoj maurya <[EMAIL PROTECTED]> wrote:
hi friends,
I have one regarding query, Problem is i want to delete duplicate rows
from the table.
Please help me, tis question in one interview. Could we give a good
solution.
Thanks.
Bye
Manoj Kr. Maurya
(Software Engineer)
(Bansal's E-Tech, New Delhi)
Phone: +91-011-9868752314
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Basic programming language Computer programming languages Programming
languages Java programming language The history of computer programming
language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
--------------------------------------------------------------------
Krishan Kant Chamoli Office: +91-172-2653886
AutherGen Technology (P) Ltd., Fax: +91-172-5018485
24/3, Industrial Area, Phase - 2, Mobile: 9888263726
Chandigarh. INDIA. Pin - 160002. Email: [EMAIL PROTECTED]
--------------------------------------------------------------------
Send instant messages to your online friends
http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
SPONSORED LINKS
Basic
<http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Basic
+programming+language&w2=Computer+programming+languages&w3=Programming+l
anguages&w4=Java+programming+language&w5=The+history+of+computer+program
ming+language&c=5&s=176&.sig=clJRDppRYABhs6xUhzokKw> programming
language
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=B
asic+programming+language&w2=Computer+programming+languages&w3=Programmi
ng+languages&w4=Java+programming+language&w5=The+history+of+computer+pro
gramming+language&c=5&s=176&.sig=RiWZhYTiihJ1rWfeFgB2sg> programming
languages
Programming
<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Basic+prog
ramming+language&w2=Computer+programming+languages&w3=Programming+langua
ges&w4=Java+programming+language&w5=The+history+of+computer+programming+
language&c=5&s=176&.sig=2BgLsjKfGvxPndstKBMU9g> languages
Java
<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Basic+
programming+language&w2=Computer+programming+languages&w3=Programming+la
nguages&w4=Java+programming+language&w5=The+history+of+computer+programm
ing+language&c=5&s=176&.sig=4wWSX5WKx7BCK9SrMVdrxQ> programming
language
The
<http://groups.yahoo.com/gads?t=ms&k=The+history+of+computer+programming
+language&w1=Basic+programming+language&w2=Computer+programming+language
s&w3=Programming+languages&w4=Java+programming+language&w5=The+history+o
f+computer+programming+language&c=5&s=176&.sig=iNvYp6cfd9HwtDhK1iV-rg>
history of computer programming language
_____
YAHOO! GROUPS LINKS
* Visit your group "AspNetAnyQuestionIsOk
<http://groups.yahoo.com/group/AspNetAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
cribe>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
