TechSapphire Saturday, 2024-04-27, 9:00 PM
Site menu
Login form
News
Play Games
  • Deep Freeze
  • Ice Slide
  • Gyroball
  • Fat Fish
  • Bush Royal Rampage
  • Main » 2015 » May » 26 » SQL for Beginners
    12:29 PM
    SQL for Beginners

    SQL for Beginners

    SQL (Structured Query Language)

    • It is high level language which provide you capability to query data from any structured data source (Tables). 
    • High level language means language which is used by us to communicate (English). 
    • For learning, we will be using online SQL editor provided by W3C.
    • http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

    SQL script:

    SQL Queries:

    Using Wild Card (*) :
    Selecting all data 
    SELECT * FROM CUSTOMERS

    Specific Columns:
    SELECT CustomerName, ContactName,Address,
     City FROM CUSTOMERS

    Click to continue

    Category: Database | Views: 3884 | Added by: Admin | Tags: SQL Server, sql, oracle, Having, GROUP BY, where, Beginners, select | Rating: 0.0/0
    Total comments: 1
    1 gagan_1926  
    0
    Its very helpful for me. Thanks yogesh Sir you r doing a great job.

    Only registered users can add comments.
    [ Registration | Login ]
    Categories
    Programming [27]
    Tips for programming
    Security [2]
    Security Tips
    Google [1]
    Use google faster then ever you use
    Project [14]
    HTML [2]
    Electronics [0]
    Data Structure [0]
    Database [16]
    SQL SERVER
    SSRS [1]
    Sql Server Reporting Services
    Copyright MyCorp © 2024