DELETE Statement

The SQL AND and OR operators are used to combine multiple conditions to narrow data in an SQL statement. These two operators are called conjunctive operators.

These opera

WHERE Clause

2013-11-23, 11:15 AM By rushabhpatel381 Unit 1 , Theory 0 Comments

The WHERE clause is used to extract

SELECT DISTINCT Statement

2013-11-23, 11:13 AM By rushabhpatel381 Unit 1 , Theory 0 Comments

In a table, a column may contain many d

SELECT Statement

2013-11-23, 11:08 AM By rushabhpatel381 Unit 1 , Theory 0 Comments

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.

Data-Base Table

2013-11-23, 10:56 AM By rushabhpatel381 Unit 1 , Theory 0 Comments

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.

SQL

2013-11-23, 10:47 AM By rushabhpatel381 Unit 1 , Theory 0 Comments

SQL was initially developed at IBM.

SQL is a standard language for accessing databases.

SQL stands for Structured Query Language

SQL lets you access and manipulate d