Grex Helpers Conference

View Responses

Grex Helpers Item 109: Questions about SQL database
Entered by jaklumen on Tue Jun 18 08:40:18 UTC 2002:

I had someone ask for help saying he was having problems with entering 
SQL commands.  I eventually directed him to send an e-mail to staff.

Now, I did do a Google search and read a FAQ about SQL, but I'm afraid 
I still have little understanding on what this is supposed to do, and 
the FAQ wasn't very helpful.  Just out of curiousity, what is it 
designed for?

1 responses total.

#1 of 1 by lemmy on Thu Jun 20 19:28:14 2002:

SQL stands for "Structured Query Language". It was originally developed by
Oracle to extract information from relational databases. Every vendor of
relational database products uses some version of it to get data from their
tables. A relational database stores its information in tables. SQL statements
look something like this:

SELECT FIRST_NAME, LAST_NAME, SSN
FROM EMPLOYEE
WHERE SAL > 45000

The above statment selects the FIRST_NAME, LAST_NAME and SSN columns from the
EMPLOYEE table where the value of the SAL column is greater than 45000. It
can actually get quite complicated, but this is the basic syntax and purpose.

Response not possible - You must register and login before posting.