Explore BrainMass

Explore BrainMass

    Microsoft SQL Server 2000 Problem

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com February 24, 2021, 2:33 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/microsoft-sql-server-2000-problem-29077

    Attachments

    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 ...

    Solution Summary

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

    $2.19

    ADVERTISEMENT