Tag Archives: sql command

SQL Command To Select Distinct

select distinct list_name from CODELIST_XREF_ITEM

This SQL command will allow you to select distinctly the whole table for code lists. Continue reading →

Rule To Replace Values In SQL When Certain Value Is Found

UPDATE sap_xref
SET ROUTE = REPLACE(ROUTE, ‘EAH_IN’, ‘EAS_IN’)
WHERE ROUTE LIKE ‘SAP_EAH_IN_RFC_%’ Continue reading →