Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

My 2 Cents The Select Statement

Discussion in 'Database Management' started by Swati Mishra, Mar 17, 2016.

  1. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    The SELECT statement is used to access and retrieve data from a database. The SELECT Statement prompts the server to query a single or multiple tables in the database and return it to the client application. The keyword SELECT, FROM and WHERE make a basic select statement.
    Syntax

    SELECT[ALL/DISTINCT] select_column_list
    [INTO[new_table_name]]
    FROM[table_name/view_name][(optimizer_hints)]
    WHERE clasue
     
  2. Manish Mishra

    Yellow Belt

    Joined:
    Dec 22, 2015
    Messages:
    1,025
    Ratings:
    +159 / -0
    The select statement is the key feature of the SQL language. You cannot fire any query without the select statement. It is used in various queries made to retrieve, edit, delete a database.
     
  3. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    SELECT statement is used everywhere in SQL commands with the FROM and WHERE statement, when they three meet then make the SELECT statement.
     

Share This Page