Microsoft SQL STATEMENTS
Not what you're looking for?
I am using Microsoft SQL Server 2000
1. Database Tables
TABLE: Employees
Job_title_code
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Hire_date
Salary
TABLE: Job_title
Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary
2. Queries using the SQL GROUP statement:
A. Group employees by salary within their job code: Select the employee's last name and group them by salary within their job_title_code.
B. Select the employee's last name and group them by salary within job titles that are grouped into exempt and non-exempt.
Purchase this Solution
Solution Summary
Microsoft SQL STATEMENTS are included.
Solution Preview
Select Last_name, Salary,job_title_code from Employees
group by ...
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
C# variables and classes
This quiz contains questions about C# classes and variables.
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.
Basic Networking Questions
This quiz consists of some basic networking questions.