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 !
Missing
15 years ago
nice introduction but we need more examples and information.
ReplyDeletegood work