SQL: ANY

This following Query Explain, how to use ANY in SQL Query.

USE pubs

GO

SELECT au_lname, au_fname

FROM authors WHERE city = ANY (SELECT city FROM publishers)

GO