Looking For Something ...?

Monday, June 22, 2009

What Is SQL ?

SQL : Structure Query Language .


SELECT SALARY FROM BELOW ;



NO ! i wasn`t talking to you ... that was a SQL QUERY !!


SELECT : Backbone of any SQL QUERY .. it means you want the server to View a COLUMN.

SALARY : is the COLUMN NAME .

FROM : REQUIRED IN EVERY SQL QUERY .. points to reference TABLE .

BELOW : NAME of the TABLE containing data . while ; is used to end any SQL QUERY .


SQL : USES ENGLISH WORDS WHICH IS EASIER TO REMEMBER AND TO GUESS TOO !!

when you are issuing a SQL QUERY it looks like an order to someone , like the previous EXAMPLE .


* Other Useful SQL Hints :

- WHERE : can be used to restrict data output .
- ORDER BY : can be used to order the output according to a string supplied by user ....... DEFAULT : ASCENDING ORDER .

SELECT NAME , SALARY , DEPARTMENT
FROM EMPLOYEES
WHERE NAME LIKE 'Ahmed'
ORDER BY SALARY ;

THAT WAS A SHORT INTRODUCTION TO SQL ... there are millions of things you can do using SQL !

1 comment:

  1. nice introduction but we need more examples and information.
    good work

    ReplyDelete