Database System Concepts, Abraham Silberschatz, Henry F. Korth, S. Sudarshan, 2020 (McGraw-Hill Education) - Provides a comprehensive academic foundation for database systems, including detailed explanations of SQL syntax and semantics, such as the SELECT statement.
SELECT, PostgreSQL Global Development Group, 2023 - Official documentation for the PostgreSQL database, offering a precise and comprehensive guide to the SELECT statement, applicable to standard SQL principles.