This preview shows page 1. Sign up to view the full content.
Unformatted text preview: date and employee number for each employee, with employee number appearing first. Save your SQL statement to a file named p1q7.sql . 8. Run your query in the file p1q7.sql . 9. Create a query to display unique jobs from the EMP table. 10. Load p1q7.sql into the SQL buffer. Name the column headings Emp #, Employee, Job, and Hire Date, respectively. Rerun your query. 11. Display the name concatenated with the job, separated by a comma and space, and name the column Employee and Title. 12. Create a query to display all the data from the EMP table. Separate each column by a comma. Name the column THE_OUTPUT....
View Full Document
This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.
- Summer '10