Talk:Select (SQL)

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

— Preceding unsigned comment added by Stolze (talk • contribs)

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