SQL continuation in SFMC Subodh

 SQL continuation in SFMC

What is TOP?

Think of TOP as a VIP pass.

In SQL terms:

• TOP N = fetch first N records from your data set.

• Works with or without sorting, but sorting makes it predictable.

Source DE:

Query Activity

SELECT TOP 5 * FROM [subodh_DE]

We get the option to append, update, or overwrite

Target DE:

SFMC SQL: Understanding the WHERE Clause – Filtering Data

The WHERE clause in Salesforce Marketing Cloud (SFMC) SQL is used to filter records based on conditions, making queries more targeted and efficient. It helps select only the necessary data rather than retrieving all records.

Query Activity

Case 1) SELECT TOP 5 * FROM [subodh_DE] WHERE PurchaseAmount >= '750'

Target DE:

Case 2) SELECT TOP 5 * FROM [subodh_DE] WHERE PurchaseAmount >= '750' ORDER BY LastPurchaseDate DESC

Target DE:

Case 3) SELECT TOP 5 CustomerID,FullName,PurchaseAmount,LastPurchaseDate FROM [subodh_DE] WHERE PurchaseAmount <> '750' ORDER BY LastPurchaseDate ASC

Target DE:

Case 4) SELECT TOP 5 CustomerID,EmailAddress,PurchaseAmount,LastPurchaseDate FROM [subodh_DE] WHERE FullName ='Sarah Connor' AND PurchaseAmount > '750' ORDER BY LastPurchaseDate ASC

Target DE:

📍 1. Using Comparison Operators in the WHERE Clause

Comparison operators are used to compare values in a Data Extension.

✅ Available Operators:

Operator	Meaning	Example
=	Equal to	WHERE Status = 'Active'
!= or <>	Not equal to	WHERE Country != 'India'
<	Less than	WHERE Age < 30
>	Greater than	WHERE Purchases > 5
<=	Less than or equal to	WHERE Discount <= 20
>=	Greater than or equal to	WHERE Revenue >= 1000

📍 2. Logical Operators: AND, OR, NOT

✅ Available Logical Operators:

Operator	Meaning	Example
AND	Both conditions must be true	WHERE Country = 'India' AND Status = 'Active'
OR	Either condition can be true	WHERE Status = 'Inactive' OR Purchases > 10
NOT	Negates a condition	WHERE NOT (Country = 'India')