Purchase Solution

Microsoft SQL Server 2000 Problem

Not what you're looking for?

Ask Custom Question

Please help with the following problem involving programming languages.

I am using Microsoft SQL Server 2000

1. Using the database and tables in the attached doc, write Microsoft SQL statements and enter ten more records into the employee table. Check the results by selecting all of the columns from both of your tables

2. Using the updated database, write the following queries using the SQL GROUP statement:
A. Group employees by job code: Select the employee's last name and group them by job_title_code.
B. Group employees by salary: Select the employee's last name and group them by salary.

Purchase this Solution

Solution Summary

The following posting helps with a problem regarding programming languages. This solution helps with a problem involving the Microsoft SQL server 2000.

Solution Preview

I am using Microsoft SQL Server 2000

1. Using the database and tables in the attached doc, write Microsoft SQL statements and enter ten more records into the employee table. Check the results by selecting all of the columns from both of your tables

One such record insetrion can be ...

Purchase this Solution


Free BrainMass Quizzes
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.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Basic Networking Questions

This quiz consists of some basic networking questions.

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.

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.