Hi, My mistake I have written DELECT. It is SELECT KK Ali Husain <[EMAIL PROTECTED]> wrote: 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] 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 AuthorGen 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 --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
