SQL Statements

Home/SQL/SQL Statements

SQL use the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


All SQL queries perform some type of data operation such as selecting data, inserting/updating data, or creating data objects such as SQL databases and SQL tables.
Each query statement begins with a clause such as SELECT,UPDATE, CREATE or DELETE and ends with semicolon(;)

Important point to be noted is that SQL is not case sensitive language which means SELECT and select have same meaning in SQL statements but MySQL make difference in table names. So if you are working with MySQL then you need to give table names as they exist in the database.

SQL Statements

We can classify the SQL statements as follows:

Data retrieval SELECT
Data manipulation language (DML) INSERT
UPDATE
DELETE
Data definition language (DDL) CREATE
ALTER
DROP
RENAME
TRUNCATE
Transaction control COMMIT
ROLLBACK
SAVEPOINT
Data control language (DCL) GRANT
REVOKE

Example table to explain these commands:

We will use the following table to explain the next few chapters, assume this table name as ‘Employee‘.

EID Department Name Salary

1

Research Ravi

22000

2

HR Mike

33000

3

Admin Neel

25000

4

Sales Anna

30000

5

HR Jo

20000

6

Admin Sunil

25000

7

Sales Mark

28000

8

Research Bill

35000

9

HR Tim

40000

10

Research Sharan

32000

Select Statement:

SELECT QUERY allows you to retrieve records from one or more tables from database.

Syntax:

[code language=”sql”] SELECT columns FROM tables WHERE <condition>

We often us WHERE Clause with SELECT Statement:

[code language=”sql”] Where {expression | column} “operator” {expression | column}[and|or] {expression | column} “operator” {expression | column}

Examples on SELECT:


Example 1: Retrieving entire data from Employee table:

[code language=”sql”] SELECT * FROM Employee

Here * indicates all the columns of the table.

Output:

EID Department Name Salary

1

Research Ravi

22000

2

HR Mike

33000

3

Admin Neel

25000

4

Sales Anna

30000

5

HR Jo

20000

6

Admin Sunil

25000

7

Sales Mark

28000

8

Research Bill

35000

9

HR Tim

40000

10

Research Sharan

32000


Example 2: Retrieving the data from Employee table where the department is Research:

[code language=”sql”] SELECT * FROM Employee WHERE Department="Research"

Here * indicates all the columns of the table.

Output:

EID Department Name Salary

1

Research Ravi

22000

8

Research Bill

35000

10

Research Sharan

32000


Example 1: Retrieving EID and Name from Employee table where salary is grater than 22000:

[code language=”sql”] SELECT EID, Name FROM Employee WHERE Salary>22000

Here * indicates all the columns of the table.

Output:

EID Name

2

Mike

3

Neel

4

Anna

6

Sunil

7

Mark

8

Bill

9

Tim

10

Sharan


We will see more examples on SELECT statement later with more examples.

LIMITED TIME OFFER
By |December 25th, 2012|SQL|1 Comment

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

One Comment

  1. mano January 8, 2016 at 3:24 PM - Reply

    how to make not equal to statement in EXCEL ADO, give example

Leave A Comment


Related pages


windows activate vbafilesystemobject referencevba macros tutorialproject milestone template pptvlookup and hlookup tutorial pdfcheckboxes in excelactivex control propertiesvba sql insertvba excel closedashboards with excelcalculate difference between two dates in excelmicrosoft excel nested ifunhide excel workbookuse of offset function in excelaccess macro tutorialprint function vbamacro commands in excelvba inputbox passwordexcel vba addressuseful macros for excelexcel vba objectsdata control language in sql with examplevisual basic msgboxinsert a checkbox in excelhow to generate charts in excelsumif function excel 2013excel vba form examplesmacro protect sheetsas books for beginnersexcel project dashboard templategrant sql commanddelete duplicate values in excelvba meaningsimple excel vba examplesfind duplicate entry in excelspotfire basicsexcel chart layoutwrite macro in excelsql dml ddl dclhow to delete specific rows in excelsql written interview questionshow to unhide a cell in excelexcel vba color codesremove blank rows excelvb listbox add itemvba stepprotect sheet vbavba activate worksheetcolorindex excelexcel vba end xldownmastering excel 2010vba excel lookupproject portfolio template exceldelete empty cells excelmsgbox syntax in vbvlookup macrocheckbox in excelhow to delete comment in excelloop through worksheets vbaexcel macro copy cellmacro delete rowpaste special values macrowhat is vlookup in ms excelmultiple if statement excelexcel vba save worksheetexcel match typeshow developer tab in word 2010vba option button selectedexcel how to sort alphabeticallyexcel macro buttonshow to insert comment in excelexcel macros for beginnersvba print worksheet