Amen! From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, January 12, 2021 10:03 AM To: [email protected] Subject: Re: [EXT] [RBASE-L] - Tip of the Day: Specify a WHERE Clause with the DELETE DUPLICATES Command
CAUTION: This Email is sent from outside our organization. Please DO NOT Click on any links or open any attachments unless you recognize the sender. Please forward any Suspicious Email "as an attachment" to [email protected]<mailto:[email protected]> And the best keeps getting better! Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: "A. Razzak Memon" <[email protected]> To: [email protected] Date: 01/12/2021 09:58 AM Subject: [EXT] [RBASE-L] - Tip of the Day: Specify a WHERE Clause with the DELETE DUPLICATES Command Sent by: [email protected] ________________________________ Tuesday, January 12, 2021 Tip of the Day: Specify a WHERE Clause with the DELETE DUPLICATES Command Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) Build.........: 10.5.3.20112 or higher Sections......: Commands Keywords......: Delete, Duplicate, WHERE, subset Did you know that the DELETE DUPLICATES command can now be used with a WHERE clause? The enhanced DELETE DUPLICATES command capability allows the deletion to be limited to a particular subset of data with a WHERE clause. DELETE DUPLICATES FROM TransMaster USING TransID, EmpID + WHERE TransDate > 01/01/2020 The time-saving feature prevents having to pull data out of a table, perform the duplicate deletion, and then put the data back in. Very Best R:egards, Razzak. https://www.rbase.com<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.rbase.com%2F&data=04%7C01%7Clhannaw%40bronxleb.org%7C9033c0eacf454dcc018f08d8b70b1ba6%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637460605627086967%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=hFvYlzmJkn4%2BUViDwGC71ukUTCyHbjwchqAACtzPA8k%3D&reserved=0> http://www.facebook.com/rbase/<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.facebook.com%2Frbase%2F&data=04%7C01%7Clhannaw%40bronxleb.org%7C9033c0eacf454dcc018f08d8b70b1ba6%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637460605627086967%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=mIsMlRVtoiJv7cpNw5OR%2BjTmSLl9zKZBD0%2Ft7zrzbR4%3D&reserved=0> -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=04%7C01%7Clhannaw%40bronxleb.org%7C9033c0eacf454dcc018f08d8b70b1ba6%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637460605627096965%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=F0rVKqrWmWoEZkUkC3RNkY6GUE7f2EruZCzAcoGNrQY%3D&reserved=0> --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1MKc4m-1keVNi1Hrw-00Kz2q%40mrelay.perfora.net<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2F1MKc4m-1keVNi1Hrw-00Kz2q%2540mrelay.perfora.net&data=04%7C01%7Clhannaw%40bronxleb.org%7C9033c0eacf454dcc018f08d8b70b1ba6%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637460605627096965%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=X%2FBhfMZyoskHTVeGQ99JCDRIpMgzj5yXUajFaRn4M2g%3D&reserved=0>. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=04%7C01%7Clhannaw%40bronxleb.org%7C9033c0eacf454dcc018f08d8b70b1ba6%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637460605627106955%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=dKW0ZHJCPgEnjH197e8anvqUBD%2F8q8pCNWHEuVs68qw%3D&reserved=0> --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/OF11EC5E14.A4D4AFE5-ON8525865B.0052968D-8525865B.0052A23C%40aksteel.com<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2FOF11EC5E14.A4D4AFE5-ON8525865B.0052968D-8525865B.0052A23C%2540aksteel.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=04%7C01%7Clhannaw%40bronxleb.org%7C9033c0eacf454dcc018f08d8b70b1ba6%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637460605627106955%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=DihMnY1khnncHQmBma6mV8D8sXw9TMvn%2FIsBGz4MkIk%3D&reserved=0>. CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/MN2PR11MB3901D3A005AD70B6FB89C108DFAA0%40MN2PR11MB3901.namprd11.prod.outlook.com.
