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]

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]