SQLAssign - WHERE EMP_LNAME = 'Lewis' AND EMP_FNAME =...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Timothy Martens INFO 1620 WW --Put your statements under the appropriate question number. - --Question #1 - SELECT * FROM vendor F --Question #2 - --Question #3 - SELECT COUNT(*) FROM employee F --Question #4 - SELECT P_CODE, P_DESCRIPT FROM product F --Question #5 - SELECT * FROM employee WHERE EMP_YEARS > 10 W --Question #6 - UPDATE employee SET EMP_TITLE = 'Mrs.'
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: WHERE EMP_LNAME = 'Lewis' AND EMP_FNAME = 'Rhonda'; W--Question #7-select * from employee where EMP_HIRE_DATE LIKE '%DEC%' w--Question #8-select V_NAME from vendor ORDER BY V_NAME DESC O--Question #9---Question #10---Question #11---Question #12---Question #13---Question #14---Question #15...
View Full Document

This note was uploaded on 12/30/2009 for the course INFO 1620 taught by Professor Wood,b during the Spring '09 term at Metropolitan Community College- Omaha.

Page1 / 2

SQLAssign - WHERE EMP_LNAME = 'Lewis' AND EMP_FNAME =...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online