I am trying to query only 10 records and using LIMIT in query, but it is giving me the following error :
An error occurred while checking the query syntax. Errors: Incorrect syntax near 'LIMIT'.
Following is my query:
SELECT SubscriberKey, EmailAddress FROM MASTER_IMPORT WHERE EmailAddress LIKE "%gmail.com" LIMIT 10
Anything that I'm doing wrong here?