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
- Summer '10
- emp, emp table, SQL> SELECT, column headings Emp