Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to find duplicate record
Dear ClaireHsu Thank u very much, actually i hav created a table and a form . it works like this, i have placed an order with A, (order no = 2000)for qnty 200pics i will receive only 50 pics first time against this order (2000) vide order recd no say 3456. agian i will receive 50 pics against...- yogs20
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How to find duplicate record
Hi, I have a table where i have 'Order No' and 'Order Recd No'. 'Order No' may appears many times, I want the 'Order Recd No' should come only once against the 'Order No'. please tell me the SQL statement to find the 'Order Recd No' number entered is already exsists in the table or not. please...- yogs20
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
