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]
------------------------ 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/
