Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    The SQL SELECT Statement

    Uploaded by

    Hardik Patel
    The SQL SELECT statement is used to select data from a database. It retrieves data from one or more tables and constructs a result table from the rows and columns of the tables. The SELECT statement syntax includes specifying columns to select from the table and using wildcards to select all columns. An example demonstrates selecting specific columns or all columns from the Customers table in the Northwind sample database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    The SQL SELECT Statement

    Uploaded by

    Hardik Patel
    25 views2 pages
    The SQL SELECT statement is used to select data from a database. It retrieves data from one or more tables and constructs a result table from the rows and columns of the tables. The SELECT statement syntax includes specifying columns to select from the table and using wildcards to select all columns. An example demonstrates selecting specific columns or all columns from the Customers table in the Northwind sample database.

    Original Description:

    dsf

    Original Title

    sql3

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The SQL SELECT statement is used to select data from a database. It retrieves data from one or more tables and constructs a result table from the rows and columns of the tables. The SELECT statement syntax includes specifying columns to select from the table and using wildcards to select all columns. An example demonstrates selecting specific columns or all columns from the Customers table in the Northwind sample database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    25 views2 pages

    The SQL SELECT Statement

    Uploaded by

    Hardik Patel
    The SQL SELECT statement is used to select data from a database. It retrieves data from one or more tables and constructs a result table from the rows and columns of the tables. The SELECT statement syntax includes specifying columns to select from the table and using wildcards to select all columns. An example demonstrates selecting specific columns or all columns from the Customers table in the Northwind sample database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    SQL SELECT Statement

    Previous
    Next Chapter

    The SELECT statement is used to select data from a database.

    The SQL SELECT Statement


    The SELECT statement is used to select data from a database.
    The result is stored in a result table, called the result-set.

    SQL SELECT Syntax


    SELECT column_name,column_name
    FROM table_name;

    and
    SELECT * FROM table_name;

    Demo Database
    In this tutorial we will use the well-known Northwind sample database.
    Below is a selection from the "Customers" table:

    CustomerID

    CustomerName

    ContactName

    Address

    Alfreds Futterkiste

    Maria Anders

    Obere Str. 57

    Ana Trujillo Emparedados y helados

    Ana Trujillo

    Avda. de la Constitucin

    Antonio Moreno Taquera

    Antonio Moreno

    Mataderos 2312

    Around the Horn

    Thomas Hardy

    120 Hanover Sq.

    Berglunds snabbkp

    Christina Berglund

    Berguvsvgen 8

    SELECT Column Example


    The following SQL statement selects the "CustomerName" and "City" columns
    from the "Customers" table:

    Example
    SELECT CustomerName,City FROM Customers;
    Try it yourself

    SELECT * Example
    The following SQL statement selects all the columns from the "Customers"
    table:

    Example
    SELECT * FROM Customers;
    Try it yourself

    Navigation in a Result-set
    Most database software systems allow navigation in the result-set with
    programming functions, like: Move-To-First-Record, Get-Record-Content,
    Move-To-Next-Record, etc.
    Programming functions like these are not a part of this tutorial. To learn
    about accessing data with function calls, please visit our ASP tutorialor
    our PHP tutorial.

    You might also like