|
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: 4097 |
Added by: Admin
| Tags: SQL Server, sql, oracle, Having, GROUP BY, where, Beginners, select
| Rating: 0.0/0 |
Total comments: 1 | |
|
|
|
|
|
|