Talk:Select (SQL)

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases

What is the justification for this page? I think this example should stay on the SQL page. Besides, the phrase "a select" strikes me as sloppy and uncommon. I would use "a select-from-where" or "a select expression" but never "a select". Moreover, the article on SQL should contain examples of SQL statements, so I don't see why these were moved and not just copied. -- Jan Hidders 16:02, 19 May 2004 (UTC)[reply]

The article begins "A SELECT statement ...". This refers to a particular kind of "statement", that kind which involves the keyword "SELECT". I don't understand your question, unless you think no SQL keyword should have a separate article? --Phil | Talk 16:16, May 19, 2004 (UTC)

I was trying to make several points. To begin with, indeed, I don't think there is at this moment enough justification for a separate page for select statements. But if we do, then the title shouldn't be simply "select" but it should be "select statement". And finally, having such a page does not mean that all examples of select expressions should be moved from SQL to this page. The SQL page should at least contain one or two illustrative examples of select statements. -- Jan Hidders

Missing information

I think that we should also explain a few more details on the SELECT statement, namely:

joins and the various join types
set operations (EXCEPT, UNION, ...)
subselects (it is there, but badly organized)
relationship to cursors
use of expression and host-variables

--Stolze 18:47, 24 October 2006 (UTC)[reply]

Many of these aren't here because they have their own topics. -- Mikeblas 18:00, 22 October 2006 (UTC)[reply]

Joins, UNION, and cursors are there; a proper link should occur in this topic here nevertheless. But the others are distinctively missing completely. Or do you have some links to those topics? --Stolze 18:46, 24 October 2006 (UTC)[reply]

Merge

Recommend merging UPDATE, INSERT, DELETE, MERGE and SELECT statements into DML article and redirecting these statements there. Comments? SqlPac 05:21, 17 May 2007 (UTC)[reply]

If the article on SELECT is moved, I am only concerned that SELECT is presented in a promient position (some sort of emphasis such as a leading section) because I feel that understanding how the SELECT works and operates is essential and fundamental to all DML and DDL statements in SQL. Right now I am happy with it being a separate article and would not recommend a merge into any other article. // Brick Thrower 18:13, 18 May 2007 (UTC)[reply]

SELECT is arguably the most important statement in SQL (definitely the most widely used), and would receive a prominent position. It would also encompass a large portion of the article as well. My main concern is that we have one or two paragraph stubs for the following DML statements and clauses: UPDATE, INSERT, DELETE, MERGE, FROM, WHERE, TRUNCATE, GROUP BY, HAVING, ORDER BY, etc. It doesn't make sense (to me anyway) to have a single article's worth of closely-related DML content spread out around a dozen or so separate 1-2 paragraph article stubs. SqlPac 18:53, 18 May 2007 (UTC)[reply]

POLICY DEBATE: Use of source code and other examples in articles

Someone started a policy debate concerning the use of source code in articles, that seems to directly impact this (and possibly other Database articles). See below for details:

I have opened a debate on the use of source code and other examples in Wikipedia articles. It seems that many pieces of example source code etc. currently in Wikipedia violate Wikipedia policy, so we need to either clarify or change the situation. Depending on the result of the discussion, this may result in a number of source code examples being summarily removed from computing articles!

Please reply there, not here, if you wish to contribute.—greenrd 10:50, 18 May 2007 (UTC)[reply]

Thanks.SqlPac 15:10, 18 May 2007 (UTC)[reply]