| |
| | Introduction to Structured Query Language (Site not responding. Last check: 2007-09-19) |
 | | First, SQL finds the rows where the salary is greater than $60,000 and the position column is equal to Manager, then taking this new list of rows, SQL then sees if any of these rows satisfies the previous AND condition or the condition that the Benefits column is greater than $12,000. |
 | | This query shows the total of all salaries in the table, and the average salary of all of the entries in the table. |
 | | If your query, on the other hand, returns multiple rows, you will have to use the Fetch statement, and quite probably, some sort of looping structure in your program will be required to iterate processing on each returned row of the query. |
| riki-lb1.vet.ohio-state.edu /mqlin/computec/tutorials/SQLTutorial.htm (8861 words) |
|