Search this blog

Tuesday, January 20, 2009

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

No comments:

Post a Comment