write SQL code list all employee name and employee number (by this order) for all employees...

Question

Question

write SQL code list all employee name and employee number (by this order) for all employees...

write SQL code list all employee name and employee number (by this order) for all employees with job code 709

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

In order to provide correct and working SQL queries, you would need to provide the table description which contains the table and column names.

Since you have not provided the table description, i am guessing the table and column names and providing you the query. Hence, the query might need some changes like change of table and column names in order to run successfully. In case you have any doubt, reach out to me via the comments section.

QUERY

SELECT EmpNum, FirstName, LastName FROM EMPLOYEES WHERE JobCode = 709 ORDER BY EmpNum;

Add a comment

Answer 2

Similar Homework Help Questions

write SQL code to list the employee first name, last name, and salary from the employee...

write SQL code to list the employee first name, last name, and salary from the employee table and the department from the jobs table
1) Write a SQL code in order to create a table name Employee with Emp_ID (3...

1) Write a SQL code in order to create a table name Employee with Emp_ID (3 characters), Last_Name (20 characters), and First_Name (15 characters), the primary key is Emp_ID (Note: make sure this code will run on SQL view on Access database) 2) Write a SQL code to remove the table Employee that will remove both the structure and the content of the table. (
Write an SQL statement that will display the Employee ID, full name (all capital) and Job...

Write an SQL statement that will display the Employee ID, full name (all capital) and Job ID of all employees that belong to a department with Department ID 20 and whose Job ID has a substring “rep”.

Write an SQL statement that will display the Employee ID, First name (only last 2 letters),...

Write an SQL statement that will display the Employee ID, First name (only last 2 letters), phone number (replace . by /) of all employees whose job Id has a word ‘REP’.
Write a T-SQL query to display the emp code, emp lname, employee job code, from the...

Write a T-SQL query to display the emp code, emp lname, employee job code, from the employee table joining the job table where the employee job code equals the job table job code. Order the output by employee job code. Copy and paste the query and the output into your assignment document. (hint: use table aliases).
SQL code on a mac MySQLWorkbench code: Retrieve all the columns for employees whose first name...

SQL code on a mac MySQLWorkbench code: Retrieve all the columns for employees whose first name is 5 letters. Retrieve all the columns for employees whose first name is 5 letters and ends with an a Retrieve all the columns for employees whose first name is 5 letters and starts with a J and ends with an a

Write SQL Queries for the following Select the employee name and no of departments each employee...

Write SQL Queries for the following Select the employee name and no of departments each employee works for Select the employee names with salary greater than average salary of all employees Select the department names with no manager assigned yet. Select the employee names who work for more than 1 department. Select the employee names and their manager names (keep in mind, one employee works for multiple departments so they will have multiple managers). Select the name and salary of...
Hi i need to write an SQL Query to list the given for these questions below...

Hi i need to write an SQL Query to list the given for these questions below Example: SELECT emp_lname -- but it doent seem to work --1. Give a Listing of all the employees having their first name, last name and full name, order the report by the employee's last name --2. Give a listing of all employees that have a last name that begins with the letters between A-K --3. Give a Listing of all the employees having their...
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...

SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee table. If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should look as follows - 'Stephen (Employee ID - 777) was hired on the 1st of January, 2016 – Department: 90'. Note - The date should not have preceding...

Using the following tables write a sql command: List the full name and the total number...

Using the following tables write a sql command: List the full name and the total number of transactions handled by the full time employee. Rank your results in descending order on the total number of transactions. Table: MEMBERS Column Data Type Length Precision Scale Nullable MEMBERID NUMBER 4 0 No MFIRST VARCHAR2 25 No MLAST VARCHAR2 25 No STREET VARCHAR2 64 No CITY VARCHAR2 25 . No STATE VARCHAR2 2 . No ZIPCODE NUMBER 0 No CREDITLIMIT NUMBER 7 2...

write SQL code list all employee name and employee number (by this order) for all employees...

Homework Answers

Add Answer to:
write SQL code list all employee name and employee number (by this order) for all employees...

Post as a guest

Earn Coins

write SQL code to list the employee first name, last name, and salary from the employee...

1) Write a SQL code in order to create a table name Employee with Emp_ID (3...

Write an SQL statement that will display the Employee ID, full name (all capital) and Job...

Write an SQL statement that will display the Employee ID, First name (only last 2 letters),...

Write a T-SQL query to display the emp code, emp lname, employee job code, from the...

SQL code on a mac MySQLWorkbench code: Retrieve all the columns for employees whose first name...

Write SQL Queries for the following Select the employee name and no of departments each employee...

Hi i need to write an SQL Query to list the given for these questions below...

SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...

Using the following tables write a sql command: List the full name and the total number...

write SQL code list all employee name and employee number (by this order) for all employees...

Homework Answers

Add Answer to: write SQL code list all employee name and employee number (by this order) for all employees...

Post as a guest

Earn Coins

Add Answer to:
write SQL code list all employee name and employee number (by this order) for all employees...