SQL QUERIES
Not what you're looking for?
I am using MS SQL SERVER 2000 (I have the database built), I would like to run these quieries.
Using the database and tables write SQL queries using BETWEEN, LIKE and UNION:
1. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection (use salaries to restrict the data).
2. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection (use hire dates to restrict the data).
3. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection (use telephone area codes to restrict data).
4. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection (use zip codes to restrict data).
5. Write a SQL query that uses UNION of the two tables to produce a third table.
Table: Employee
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Job_title_code
Hire_date
Salary
Table: Job_title
Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary
6. Write a SQL INSERT statement (enter ten records into the employee table) and (enter five records into the job_title table
Purchase this Solution
Solution Summary
SQL QUERIES are noted.
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes
This quiz contains questions about C# classes and variables.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Javscript Basics
Quiz on basics of javascript programming language.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.