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 http://www.facebook.com/rbase/ -- 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/1MKc4m-1keVNi1Hrw-00Kz2q%40mrelay.perfora.net . 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 --- 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/OF11EC5E14.A4D4AFE5-ON8525865B.0052968D-8525865B.0052A23C%40aksteel.com.
