Everything about Select (SQL)

🧭 Start here: a 6-step reading path

1. Read the overview: Select (SQL)A 5-minute orientation
2. Pick up a classic book: The little SAS bookThe most-reprinted book on the subject
3. Read the landmark paper: Study on the Optimization Method of Select Query Sentence in Standard SQL LanguageCited 1 times
4. Go sideways: SQL syntaxA closely related topic
5. Go sideways: Order byA closely related topic

🏆 Landmark papers (most cited)

• Study on the Optimization Method of Select Query Sentence in Standard SQL Language

  Yuqing Geng, Chunsheng Zhang · 2009 · Computer and Information Science · 1 citations

• Internal Processing Modeling (Ipm) of the Sql Select Statement Command

  Hasan Ali Idhaim, Ayoub Alsarhan, Muhsen Alkhalidy · 2022 · SSRN Electronic Journal · 0 citations

• Improving Speed Performance of Select Random Query in SQL Database

  Muhammad Nur Yasir Utomo, Alvian Bastian, Anggun Winursito · 2020 · INTEK: Jurnal Penelitian · 0 citations

• An Evolutionary Approach to Test SELECT SQL Statements using Mutation Analysis

  A.C Monção, C.G Camilo Júnior, L.T. Queiroz · 2017 · IEEE Latin America Transactions · 0 citations

• Analysis of Data Mining Dataset Using Fuzzy Based Unnested Select SQL Queries

  D. Veni, K.R. Chandran · 2015 · Research Journal of Applied Sciences, Engineering and Technology · 0 citations

• AUTOMATED CHUVASH-RUSSIAN TRANSLATOR: IMPLEMENTATION USING THE METHOD OF SOFTWARE SIMULATION OF SELECT-TYPE SQL QUERIES

  A.P. Dimitriev, T.A. Lavina · 2022 · Современные наукоемкие технологии (Modern High Technologies) · 0 citations

📚 Books worth reading

• The little SAS bookLora D. Delwiche, Susan J. Slaughter · 1995
• Statistical Atlases and Computational Models of the Heart. Imaging and Modelling ChallengesOscar Camara · 2012
• Database system conceptsAbraham Silberschatz · 1997
• Learning PHP, MySQL & JavaScriptRobin Nixon · 2009
• Access database design & programmingSteven Roman · 1997
• SQL bibleAlex Kriegel, Boris M. Trukhnov · 2007
• Data science from scratchJoel Grus · 2015
• Select-- SQLLawrence R. Newcomer · 1992

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics

• SQL syntax The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. This standard is not freely available. Despite…
• Order by An ORDER BY clause in SQL specifies that a SQL SELECT statement returns a result set with the rows being sorted by the values of one or more columns. The…
• Insert (SQL) An SQL INSERT statement adds one or more records to any single table in a relational database. Insert statements have the following form: INSERT INTO table…
• Join (SQL) A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table. The operation corresponds to a join operation…
• Hierarchical and recursive queries in SQL A hierarchical query is a type of SQL query that handles hierarchical model data. These are useful for working with databases of graph-structured data…
• Null (SQL) In the SQL database query language, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the…
• Correlated subquery In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values…
• Language Integrated Query Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET framework component that adds native data querying abilities to .NET languages…