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 And The Where 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 everywhere in the query with the WHERE statement both are used for the retrieve the information from the database and display it.
    Syntax

    SELECT column_list
    FROM table_name
    WHERE search_condition

    where search condition may be any search condition.
     
  2. Manish Mishra

    Yellow Belt

    Joined:
    Dec 22, 2015
    Messages:
    1,025
    Ratings:
    +159 / -0
    Select and where statement used to filter the data retrieval from a table. Select is use for selection of a particular table and where is used for set of condition to be followed while retrieving the data from a table.
     
  3. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    SELECT and WHERE statement filter the data retrieval from the table but it is select all data from the table according to query also.
     

Share This Page