Retrieves rows that contain all the same values in the specified data. Can be used with operators <, >, = to collect specific rows.

 

Example:

SELECT * FROM Customers_dataflex WHERE customercountry = 'USA' AND customerstate = 'WA'